From: Paul Nowosielski
Date: September 15 2008 12:10pm
Subject: make In statement non case sensitive?
List-Archive: http://lists.mysql.com/mysql/214467
Message-Id: <152244.7602.qm@web30405.mail.mud.yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

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