I'm having a problem with a MYSQL select statement:
SELECT * FROM mydb WHERE Email = 'email@example.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.