Running a Case Sensitive Query Select String in MySql

contoh / example :
I have data in table user structure like this :

_ _ _ _ _ _ _ _ _
| ID  |  Name |
-------------------
| 1    |  Andre |
-------------------
| 2    |  andre  |
----------------------

when i using Select `ID`,`Name` from user where name = 'andre';
result is 2 row in set but i just need name 'andre' not 'Andre' , so you need case sensitive string

solution :

Select `ID`,`Name` from user where binary name = 'andre';
result is 1 row in set