MySQL queries are not case-sensitive by default. Following is a simple query that is looking for 'value'. However it will return 'VALUE', 'value', 'VaLuE', etc… Putting BINARY in front of the column will prevent the use of any index on that column.
Check the below example for your reference:
SELECT VERSION(), CURRENT_DATE; SeLect version(), current_date; seleCt vErSiOn(), current_DATE;
All of these examples are the same. It is not case sensitive.