When searching for partial strings in MySQL with LIKE you will match case-insensitive by default.
For example, Search all records un members table where name is start with “Pk”.
mysql> SELECT name FROM members WHERE name LIKE 'Pk%';
To do this add BINARY option with like statment and view the results:
mysql> SELECT name FROM members WHERE name LIKE BINARY 'Pk%';
mysql> select Name like binary 'RAVI' from members;
mysql> select Name like 'RAVI' from members;
I hope you get an idea about mysql like case sensitive.