MySQL: is a SELECT statement case sensitive?

Is a MySQL `SELECT` query case sensitive or case insensitive by default? And if not, what query would I have to send so that I can do something like the following? SELECT * FROM `table` WHERE `Value` = "iaresavage" Where in actuality, the real value of `Value` is `IAreSavage`.