On Mon, May 2, 2005 12:22 pm, Ross said: > Had a look at it and much easier to use LIKE with wildcards. Was unsure > whether the query was case sensitive that is why I asked. > > As it turns out it is not.
Actually, last time I checked, this was a COMPILE option to MySQL to be case sensitive or not in = and LIKE. The default is case insensitive. It may also be configurable in /etc/my.cnf, but I don't think it was back when I dug into this, way back when. You'd have to actually read MySQL documentation or ask on a MySQL list to get a definitive answer. -- Like Music? http://l-i-e.com/artists.htm -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
