Welcome to WebmasterWorld Guest from

Forum Moderators: open

Message Too Old, No Replies

Case insensitive conditional searches in MYSQL

case insensitive searches

8:35 pm on Mar 5, 2009 (gmt 0)

Junior Member

10+ Year Member

joined:May 1, 2004
posts: 104
votes: 0

Can someone please enlighten this newbie.

I'm having a problem with a MYSQL select statement:

SELECT * FROM mydb WHERE Email = 'me@mydomain.com'

The problem is, the address is actually stored in the database Email column as "Me@MyDomain.com" and the search doesn't find it.

I thought string searches were case insensitive, but the failure of this search has proved that this is not the case. Can someone please help by explaining how I can do a case-insentive search on columns containing string values.


8:52 pm on Mar 5, 2009 (gmt 0)


WebmasterWorld Administrator coopster is a WebmasterWorld Top Contributor of All Time 10+ Year Member

joined:July 31, 2003
votes: 2

Depends on the column type amongst other things.