Searching Text Fields - Case Sensitive?

Hi-

 

If I want to search a text field for a certain word, say 'foobar', using:

 

SELECT * FROM mydb WHERE description LIKE "%foobar%";

 

it seems to be case sensitive.  Is there a way to do it so it is NOT case-sensitive?

 

Please let me know.

Thanks,

Mike