6 Apr 2014
0.66K views
no comments
4 Jul 2014 12:00 am
in #MySQL cannot do it with any compression operator to check case sensitive value in column, so first convert your value into hash and compare with column value see code example how to do it.
Here is example of table
| case_sensitive_col_id | case_sensitive_col_val |
|---|---|
| 1 | SDTUTS.com |
| 2 | SDTuts.com |
| 3 | Sdtuts.com |
Using SHA1 for casesensitive
SELECT * FROM tbl_name WHERE SHA1(case_sensitive_col) = SHA1('SDTuts.com')
ROWS RESULT =1
Using normal compression operator
SELECT * FROM tbl_name WHERE case_sensitive_col = 'SDTuts.com' ROWS RESULT =3
