OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
make In statement non case sensitive?

From: Paul Nowosielski (paulnowosielskiyahoo.com)
Date: Mon Sep 15 2008 - 07:10:20 CDT

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