mysql case sensitive select query

by Francis 2014-06-27 10:35:24

mysql case sensitive select query using BINARY
 
select * from tablename where BINARY fieldname = '$value' 

Example : 1
select * from tablename where BINARY 'value' = 'Value' 

No result found because its case sensitive.

Example : 2
select * from tablename where 'value' = 'Value' 

Result found because its case insensitive.
 
797
like
0
dislike
0
mail
flag

You must LOGIN to add comments