[EMAIL PROTECTED] writes: > Your message cannot be posted because it appears to be either spam or > simply off topic to our filter. To bypass the filter you must include > one of the following words in your message: > > database,sql,query This is very silly. I am subscribed to the list and I used the word 'queries' below. > If you just reply to this message, and include the entire text of it in the > reply, your reply will go through. However, you should > first review the text of the message to make sure it has something to do > with MySQL. You have written the following: > > Paul DuBois writes: > >The way it works now, I have to know in which position the label > >'good' is to construct the select. I think this leads to unnecessary > >duplication (is there a function that returns the position of a label? > >I couldn't find it in the manual). > Try this: > > SELECT level + 0 from foo where level = 'good' LIMIT 1; OK, I believe this works, thanks. But I would rather have the numeric context or do select * from foo where level >= enum_pos('good') Maybe I'm just too lazy ;-) Regards, -- Adriano --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
filter again Re: Re: SELECT and (ordered) ENUMs
Adriano Nagelschmidt Rodrigues Fri, 25 May 2001 05:52:28 -0700