MySQL: Is WHERE IN clause case sensitive?

Question

I was just wondering if the IN clause in MySQL is case sensitive or not when it comes to string values. For example below. Will it display all the data regardless if it is on upper case or not?

SELECT Column1 FROM Table1 WHERE Column2 IN ('sample1','Sample2','sampLe3')

Answer 1

It is actually based on your db/table/column collation. If your collation is case-sensitive, the operator will also behave case-sensitively.