Select is not case sensitive by default


SELECT * FROM myTable WHERE 'something' = 'Something'
= 1

To make it case sensitive use a select with binary


SELECT * FROM myTable WHERE BINARY 'something' = 'Something'
//or
SELECT * FROM myTable WHERE 'something' = BINARY 'Something'
= 0
Feel free to comment if you can add help to this page or point out issues and solutions you have found. I do not provide support on this site, if you need help with a problem head over to stack overflow.

Comments

Your email address will not be published. Required fields are marked *