Select ENUM values

[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 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]

Re: Select ENUM values

[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 '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]