mysql, how to query the table comments?

comments, mysql, php

Solution

Query the COLUMNS table in the information_schema database.

SELECT a.COLUMN_NAME, a.COLUMN_COMMENT
FROM  information_schema.COLUMNS a 
WHERE a.TABLE_NAME = 'YOUR_TABLE_NAME'

You can do similar queries for any type of element in your db (ie tables, triggers, etc).

Problem

i haven't found anything on this situation, and here is my question. after i create a field in a database i can also leave a comment for that specific field, maybe a description of what that field means, etc. I would like to query after it. any ideas if this is possible? is there anything similar i could use?

Original source