Re: just going with LIKE
| From: | Richard Lynch | Date: | Wed, 04 May 2005 00:09:06 +0000 |
| Subject: | Re: just going with LIKE | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-214397@lists.php.net to get a copy of this message | ||
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