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@xxxxxxxxxxxxxx>
To: <lgs@xxxxxxxxxxx>; <php-db@xxxxxxxxxxxxx>
Sent: Tuesday, November 18, 2003 5:46 AM
Subject: Re: 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@xxxxxxxxxxx>
> To: <php-db@xxxxxxxxxxxxx>
> Sent: Tuesday, November 18, 2003 1:23 AM
> Subject: 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
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
