MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: retrieve enum values
Posted by: liu yingjiang
Date: January 04, 2008 04:53AM

what about

SELECT * FROM test
WHERE type in ('A','B','C','D')

sorry, I am misunderstanding you.
you can try this one:


SELECT concat('"', type, '"') FROM test



Edited 1 time(s). Last edit at 01/04/2008 05:00AM by liu yingjiang.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
retrieve enum values
Dacian Halmagean
January 04, 2008 02:49AM
Re: retrieve enum values
liu yingjiang
January 04, 2008 04:53AM
Re: retrieve enum values
Dacian Halmagean
January 04, 2008 06:27AM
Re: retrieve enum values
liu yingjiang
January 04, 2008 06:48PM
Re: retrieve enum values
Andrew Loree
January 06, 2008 12:45PM
Re: retrieve enum values
Dacian Halmagean
January 07, 2008 12:47AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.