Re: Query Case In-sensitive

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux