mysql search without case sensitivity
Hi,
I read mysql manual, it says by default the search is case insensitivity. But, I tried following:
mysql> SELECT * FROM myDb.myTable WHERE username = 'test980';
1 row in set (0.00 sec)
mysql> SELECT * FROM myDb.myTable WHERE username = 'TEST980';
Empty set (0.00 sec)
So the result seems it is still case sensitive. How can I search it with case insensitivity?
I use mysql Ver 14.12 Distrib 5.0.22.
Thank you.
Jim
Subject
Written By
Posted
mysql search without case sensitivity
April 10, 2008 10:06PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.