Re: Select ENUM values

2004-08-24 Thread Paul DuBois
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

Select ENUM values

2004-08-24 Thread Michael Pawlowsky
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 fo