Question: is mysql where case sensitive?
Answer: Usually our mysql queries are not case sensitive. In order to query case sensitive, you can use the mysql COLLATE clause. ... A binary collation such as utf8_bin is case sensitive as well since it compares the characters based on their numeric values.