If you are on 5.0.x you can use SELECT column_Name FROM INFORMATION_SCHEMA.columns;
INFORMATION_SCHEMA is a set of VIEWS that lets you access the database structure. See http://dev.mysql.com/doc/refman/5.0/en/information-schema.html -----Original Message----- From: Mike OK [mailto:[EMAIL PROTECTED] Sent: Thursday, January 19, 2006 10:34 AM To: mysql@lists.mysql.com Subject: Show Description options?? Hi I was looking for a command that will list the names of my columns only. I have investigated show columns but there seems to be no way to return just the names. Any suggestions?? Thanks Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]