Welcome to WebmasterWorld Guest from 54.226.147.190

Forum Moderators: open

Message Too Old, No Replies

Case insensitive conditional searches in MYSQL

case insensitive searches

     

Tourex

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.

Thanks!

coopster

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.
[dev.mysql.com...]
 

Featured Threads

Hot Threads This Week

Hot Threads This Month