Re: Case sensitive
| From: | Micah Stevens | Date: | Wed, 24 Aug 2005 18:28:26 +0000 |
| Subject: | Re: Case sensitive | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-40129@lists.php.net to get a copy of this message | ||
In fact, by issuing the following query:
SELECT "TEST" LIKE "test";
you can prove this to yourself, if it's case insensitive, it will return true
(1), otherwise false (0).
-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