is mysql query case sensitive?
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 column will prevent the use of any index on that column.