I must not understand your question. As you've asked it, the answer is: SELECT AccessRight FROM tableA;
-----Original Message----- From: Wee Chua [mailto:[EMAIL PROTECTED]] Sent: Monday, February 18, 2002 1:27 PM To: PHP (E-mail) Subject: [PHP] Php Enum Field Hi all, How can I get the preset values for Enum field inside the table. For example, table A has a field called AccessRight, the enum fields are "Read,Add,Delete". How can I write the query to get these values out from AccessRight field? Thanks, Wee -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php