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

[OllieJones]

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

[batonac]

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'");