19, 2003 2:36 PM
Subject: Re: [PHP-DB] Query Case In-sensitive
As an Oracle DBA (9+ years, versions 7.x - 9.x) I just wanted to make a correction.
The LIKE command uses wild card characters ( _ and % ) for substitutions. Oracle IS a
case-sensitive RDBMS and the LIKE command will NOT do
7:11
To
[EMAIL PROTECTED]
cc
Subject
Re: [PHP-DB] Query Case In-sensitive
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,
ki" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
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
se respond to
<[EMAIL PROTECTED]>
To
<[EMAIL PROTECTED]>
cc
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 fro
>
To: <[EMAIL PROTECTED]>
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"
>
> Quer
Hey!
At least in Postgresql you can do something like:
SELECT * FROM table where item_code ILIKE 'blabla';
But I guess it's standard, so you can use it in any DB.
Larry Sandwick wrote:
Is there a way to run a query so that it ignores the case, and the query
is not case sensitive?
The data b
From: "Larry Sandwick" <[EMAIL PROTECTED]>
> Is there a way to run a query so that it ignores the case, and the query
> is not case sensitive?
What's this have to do with PHP and what database are you using?
---John Holmes...
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe
t;[EMAIL PROTECTED]>
17-Nov-2003 14:53
Please respond to [EMAIL PROTECTED]
To
[EMAIL PROTECTED]
cc
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"
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.
Ne