Perhaps its a collatioon issue? Are you using the same characterset for
both?
Bastien
From: Micah Stevens <micah@xxxxxxxxxxxxxxxxxx>
To: php-db@xxxxxxxxxxxxx
Subject: Re: Case sensitive
Date: Wed, 24 Aug 2005 11:26:38 -0700
Not sure here, as according to my experience, and the MySQL docs, SQL
pattern
matching (as you would use with the 'LIKE' syntax) is case-insensitive.
From
the docs:
"In MySQL, SQL patterns are case-insensitive by default. Some examples are
shown here. "
http://dev.mysql.com/doc/mysql/en/pattern-matching.html
If this for some reason is different on your server, another route
(although
likely slower) is a REGEXP search..
-Micah
On Wednesday 24 August 2005 1:53 pm, Chris Payne wrote:
> Hi there everyone,
>
>
>
> I have a little problem, I have a search where people can search the
> address of a property BUT the search is case sensitive, I donâ??t WANT
it to
> be. Iâ??m using MySQL and PHP and I generally use something like WHERE
> address LIKE â??%$stringinput%â?? which works with the numbers ONLY, but
when I
> add the address if I donâ??t put a capital infront of each part of the
> address it wonâ??t show up. Any ideas how I can make it case
INSENSITIVE?
> (Think thatâ??s the correct phrase).
>
>
>
> Any help would really be appreciated.
>
>
>
> Thanks everyone
>
>
>
> Regards
>
>
>
> Chris Payne
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
