MySQL: is a SELECT statement case sensitive?

mysql select

They are case insensitive, unless you do a binary comparison.

mysql select

You can lowercase the value and the passed parameter :

SELECT * FROM `table` WHERE LOWER(`Value`) = LOWER("IAreSavage")

Another (better) way would be to use the COLLATE operator as said in the documentation

mysql select

USE BINARY

This is a simple select

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

= 1

This is a select with binary

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

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

= 0

CodeHunter