Case Sensitive Query in MySQL

The default return result of MySQL query is case insensitive, e.g.

SELECT header FROM table WHERE header = "LABEL"

Result:

label

If you want the result of the query to be case sensitive. You have to add keyword “BINARY” in front of the field name.

SELECT header FROM table WHERE BINARY header = "LABEL"

Result:

null

References:

http://emba.thu.edu.tw/chiayuan/wordpress/?p=549