Re: [PHP-DB] Case sensitive

[Bastien Koert]

Perhaps its a collatioon issue? Are you using the same characterset for 
both?

Bastien

From: Micah Stevens <[EMAIL PROTECTED]>
To: php-db@lists.php.net
Subject: Re: [PHP-DB] 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