MySQL: is a SELECT statement case sensitive?

Question

Can anyone tell me if a MySQL SELECT query is case sensitive or case insensitive by default? And if not, what query would I have to send so that I can do something like:

SELECT * FROM `table` WHERE `Value` = "iaresavage"

Where in actuality, the real value of Value is IAreSavage.

Answer 1

They are case insensitive, unless you do a binary comparison.