MySQL provides more than one method to do so:
- You can set your concerned column's COLLATION to latin_general_cs.
- If you don't like above, you can force MySQL to check for an exact case. For this you can use the BINARY keyword in your query. Simply place BINARY before the column you want to compare. Take an example:
SELECT * FROM user WHERE BINARY username = 'Adnan' AND password = 'pw12345';
Posted in: MySQL