[thelist] PHP and mySQL ENUM

rudy limeback r937 at interlog.com
Sun Jul 2 16:48:07 CDT 2000

> If I have a table that contains a column that's defined as:
> column_name ENUM("value1", "value2", "value3", "value4"),
> is it possible to retrieve the ENUM values using PHP?

hi mike

not a mysql user myself, but a quick search of the mysql.com site turned
this up --

   "If you want to get all possible values for an ENUM column,
    you should use: SHOW COLUMNS FROM table_name LIKE
   enum_column_name and parse the ENUM definition in the
   second column. "


More information about the thelist mailing list