Re: Query Case In-sensitive
| From: | ramki | Date: | Tue, 18 Nov 2003 03:46:43 +0000 |
| Subject: | Re: Query Case In-sensitive | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-31602@lists.php.net to get a copy of this message | ||
Generally in DBs, data is case sensitive.
Simply you can do an uppercase or lowercase conversion in both sides.
Ex : Select item number from item where upper(item_code) = upper("m1234");
-ramki
----- Original Message -----
From: "Larry Sandwick" <lgs@sarreid.com>
To: <php-db@lists.php.net>
Sent: Tuesday, November 18, 2003 1:23 AM
Subject: [PHP-DB] Query Case In-sensitive
> Is there a way to run a query so that it ignores the case, and the query
> is not case sensitive?
>
> The data being stored is "m1234"
>
> Query
>
> Select item number from item where item_code = "M1234" ;
>
> The query above should return the data above.
>
> TIA
>
>
>
> Larry Sandwick
>
> Sarreid, Ltd.
>
> Network/System Administrator
>
> phone: (252) 291-1414 x223
>
> fax : (252) 237-1592
>
>
>
>