[thelist] mysql - like

[Chris Price]

I'm running a query in my table to find a field which contains a 
certain word so I'm using 'like', e.g. select * from table where field 
like '%thisWord%'.

But it doesn't find 'ThisWord' or 'thisword'.

Is there a simple way to get round this capitalisation issue?

MySQL version is 4.1.20

--
Chris Price
Choctaw