MySQL Forums
Forum List  »  Newbie

mysql search without case sensitivity
Posted by: Jupiter Hce
Date: April 10, 2008 10:06PM

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

Options: ReplyQuote


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.