[thelist] mysql - like

Anthony Baratta anthony at baratta.com
Wed Aug 23 19:03:21 CDT 2006


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




More information about the thelist mailing list