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
>
