Show Comment of Fields FROM Mysql Table

You can use the query

SHOW FULL COLUMNS FROM <tablename>

If you don't want to use information_schema.