How to do case insensitive WHERE statement

[Chronicle]

Hello,
I need to do something like
SELECT * from table WHERE field = "whatever"
but it must also pick up all results that have field = WHATEVER, WhAtEvEr etc

How can i do case insensitive where search?
thanks

 

[Chronicle]

Oh. MySQL. forgot that lol...

 

[Chronicle]

Oh. Lol. I've always thought it was case sensitive. Didn't try it. Lol. Damn. Thanks.