Welcome to WebmasterWorld Guest from 188.8.131.52
Forum Moderators: open
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.