List:General Discussion« Previous MessageNext Message »
From:Jonathan Selander Date:September 15 2008 1:11pm
Subject:Re: make In statement non case sensitive?
View as plain text  
You can use

SELECT name FROM name_table WHERE LOWER(name) IN ('joe','john','harry')

If you keep all the alternatives lower-case.

Jonathan

15 sep 2008 kl. 14.10 skrev Paul Nowosielski:

> Hello,
>
> Is there a way to call an IN statement
> and have return results that are not case sensitive.
>
>
> SELECT name FROM name_table WHERE name IN ('joe','john','harry')
>
> would return the same as
>
> SELECT name FROM name_table WHERE name LIKE 'joe' OR name LIKE  
> 'john' OR name LIKE 'harry'
>
> Thank you,
>
> Paul
>
>
>
>
>
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>


Thread
make In statement non case sensitive?Paul Nowosielski15 Sep
  • Re: make In statement non case sensitive?Jonathan Selander15 Sep
  • Re: make In statement non case sensitive?Dan Nelson15 Sep
    • Re: make In statement non case sensitive?Bard Aase15 Sep
      • RE: make In statement non case sensitive?Jerry Schwartz15 Sep
        • Re: make In statement non case sensitive?Bard Aase15 Sep