Getting field ENUM options

[rmiller1985]

Is there a function that will retrieve all possible values for a MySQL ENUM field? I've looked in the manual, and it looks like the mysql_field_type() function will return "enum," but not the possible values.

If there isn't a built-in function, has anyone written something that would do something like this?

Thanks,
Rich

[liquorvicar]

if you're after a PHP function, there's nothing i'm aware of. but you could build your own function using MySQL's DESCRIBE command