Re: retrieve enum values

[liu yingjiang]

because enum has just one value stored,so you just can query the value stored in the database.

if you want all values the enum field defined,use this:
desc tablename
or
show columns from tablename
or
explain tablename
they are all the same

this can tell you something:
show columns from tablename like 'type'



Edited 2 time(s). Last edit at 01/04/2008 06:55PM by liu yingjiang.