Getting values of enumerated list

[mpociask]

I have a mysql database that has a field of enum (enumerated list) type. I want to make code that validates the input to make sure that it will match one of those allowed values. I don't want to have an array that I add to every time I add a value to the enumerated list. I want to be all automatic and modular. Is there a SQL query that will give me this info?

[coreyp_1]

This may help:

Mysql Enum
Look for the comment posted by Willem-Jan van Dinter on May 24 2003 4:14pm