mysql describe table - concatenate fields?

Question

Is there a way to use GROUP_CONCAT in the DESCRIBE table query? Was hoping for output like:

id,title,body

Rather than the typical description...

Answer 1

This should do the trick:

SELECT 
    GROUP_CONCAT(COLUMN_NAME) 
FROM INFORMATION_SCHEMA.COLUMNS 
WHERE
    TABLE_SCHEMA=DATABASE() 
AND TABLE_NAME='your-table-name';