SHOW COLUMNS FROM table needs correctly named columns in result set.

Users of SHOW COLUMNS FROM table depend on having resultset columns named Field, Type, Null, Key, Default, and maybe Extra.

Just in case this is missing in the scope of this bug, SHOW COLUMNS FROM should also support LIKE, as in:

$warehouse_table = $wpdb->prefix . "warehouse";
$warehouse_address = $wpdb->get_row("SHOW COLUMNS FROM " . $warehouse_table . " LIKE 'phone_instore'");