mySQL is not by default case sensitive....there must be something else going on. http://dev.mysql.com/doc/refman/4.1/en/case-sensitivity.html Are you searching a binary field? -----Original message----- From: Chris Price chris.price at choctaw.co.uk Date: Wed, 23 Aug 2006 16:47:29 -0700 To: thelist at lists.evolt.org Subject: [thelist] mysql - like > 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