At 11:51 -0700 8/24/04, Michael Pawlowsky wrote:
I'm wondering if there is a better way to select the
values of a ENUM field. I have a ENUM field called
greeting that has 'Mr.','Mrs.','Ms.','Dr.' in it. I
need to put these in a HTML select.

Right now I'm doing a "SHOW COLUMNS FROM global_lead
LIKE 'greeting'" and then parsing out the response for
the enum values (found on mysql site).

But I was thinking there might be a more elegant way
to do it.

Is there?

No.

--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to