Is MySQL Case Sensitive? (THE FAST ANSWER)

Is MySQL case sensitive? In MySQL, a query is not case sensitive. That is when you make a query for Boy, you will get results for every likelihood of that query like boy, Boy, bOy, Boy and so on because query in MySQL isn’t case sensitive.

As a compliment, you can easily make a case-sensitive query in MySQL with a binary operator. This will make use of the byte of the specific characters.

The easiest way to do this is SELECT * FROM `table` WHERE BINARY `column` = ‘value’

The case of a nonbinary string is different in MySQL. Nonbinary string in MySQL is case sensitive. This is a default setting and nothing is expected of you.

This is a huge info on MySQL case sensitive issues because a lot of newcomers aren’t aware of it.

MySQL case sensitive