Results 1 to 4 of 4
Sep 4, 2012, 00:09 #1
- Join Date
- Sep 2012
- 0 Post(s)
- 0 Thread(s)
How to find case insensitive duplicate values from mysql ?
I have a table "employee" having the following data:
id name 1 subhajit 2 ramesh 3 SuBhajit
I want to find the duplicate rows in the table. Thus I need a query which will return
id name 1 subhajit 3 SuBhajit
Note that two "subhajit" are of different cases.
Please help me write the query. Thanks in advance.