Re: is SELECT case sensitive
| From: | Koen Wagemans | Date: | Thu, 06 Oct 2005 08:04:46 +0000 |
| Subject: | Re: is SELECT case sensitive | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-40473@lists.php.net to get a copy of this message | ||
Select on type varchar is not case sensitive, you can make it case
sensitive with the BINARY option:
SELECT * FROM table_name WHERE BINARY column LIKE '$searching_criteria';
Koen
On 06/10/05, Ron Piggott <ron.php@actsministries.org> wrote:
> Is SELECT typically case sensitive? Is there a way to make it case
> sensitive? (In the example below can $searching_criteria become case
> sensitive?)
>
> SELECT * FROM table_name WHERE column LIKE '$searching_criteria';
>
> Ron
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>