mysql case sensitive select query

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.