Sometimes Its Become very necessary to search the query with case sensitive string in database and if you use like condition or equal condition then it will not get the desired result for you.
So here i am going to tell you how to search with case sensitive string comparison on MySQL.
SELECT * FROM `table` WHERE BINARY `column` = 'value'
Example: SELECT * FROM `student` WHERE BINARY `name` = ‘joe’
It will give you result with having ‘joe’ only.
If student table have ‘Joe’ in records then it will skip that.