Msg#: 3863801 posted 8:35 pm on Mar 5, 2009 (gmt 0)
Can someone please enlighten this newbie.
I'm having a problem with a MYSQL select statement:
SELECT * FROM mydb WHERE Email = 'firstname.lastname@example.org'
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.