SELECT options for MySQL Enum field

I needed to display the valid options for a MySQL Enum field. Table and column metadata is stored in a virtual table called INFORMATION_SCHEMA and can be queried with normal selects. To see the options for a given enum field do:

SELECT column_type FROM information_schema.columns WHERE table_name = 'MyTable' AND column_name = 'MyColumn';


Note: Replies will be formatted with PHP Markdown Extra syntax.

Name: Email (Not Required):
 
Logged IP: 54.84.65.73
To prevent spam please submit by clicking the kitten: