filter again Re: Re: SELECT and (ordered) ENUMs

[Adriano Nagelschmidt Rodrigues]

[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