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? Thanks, Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
