Access MySQL field's Comments with PHP

Question

When you are creating a field in a MySQL table, there's a 'Comments' box to fill out. How can I access the data in that 'Comments' box with PHP?

Answer 1

Poke around information_schema.

SELECT table_comment
FROM information_schema.tables
WHERE table_schema = 'myschema' AND table_name = 'mytable'

Answer 2

Use:

SHOW FULL COLUMNS FROM tbl_name

Notice keyword FULL, this is what makes MySQL to include privileges and comments info into the response.

Answer 3

SELECT 
    COLUMN_COMMENT
FROM 
    information_schema.COLUMNS
WHERE
    TABLE_NAME = 'venue'

Great to use for table column headings or more readable/secure version of real column names. Ex., The column for Venue ID is actually vid_xt

Sample Result from actual query above:

COLUMN_COMMENT
Venue ID
Venue Active
Venue Name
Location Name
Address
Accommodations
Description

Answer 4

Ah, wow. So that's what information_schema database is for. Thank you @Adam Backstrom! Then I believe below should give me the field's comments.

SELECT COLUMN_COMMENT
FROM information_schema.COLUMNS
WHERE TABLE_SCHEMA = 'mydatabase' AND TABLE_NAME = 'mytable' AND COLUMN_NAME = 'mycolumn'

Thank you for pointing me to the right direction. :-)