Re: Query Case In-sensitive
| From: | mustafa ocak | Date: | Wed, 19 Nov 2003 12:11:23 +0000 |
| Subject: | Re: Query Case In-sensitive | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-31625@lists.php.net to get a copy of this message | ||
Use "LIKE" clause instead of "="
SELECT item_number FROM item WHERE item_code LIKE 'M1234' ;
This will perform case-insensitive matching on all databases I used
before (Including Oracle, MySQL, SQL-Server)
----- Original Message -----
From: "ramki" <ramki@naturesoft.net>
To: <lgs@sarreid.com>; <php-db@lists.php.net>
Sent: Tuesday, November 18, 2003 5:46 AM
Subject: Re: [PHP-DB] Query Case In-sensitive
> 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
> >
> >
> >
> >
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>