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)

10+ Year Member

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

Depends on the column type amongst other things.

Featured Threads

Hot Threads This Week

Hot Threads This Month