MySQL query to get column names?

Question

I'd like to get all of a mysql table's col names into an array in php?

Is there a query for this?

Answer 1

IN WORDPRESS:

global $wpdb;   $table_name=$wpdb->prefix.'posts';
foreach ( $wpdb->get_col( "DESC " . $table_name, 0 ) as $column_name ) {
  var_dump( $column_name );
}