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
you can convert both of the sides to one case, similar to this:
select item_number from item where upper (item_code) = upper ("M1234");
this way you ensure that both the value in the database and the selection
variable are in one and the same case: capital. this should work in just
about every
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" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent
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
In Oracle you have a couple of choices.
(1) If you can ensure that the data stored is in one case you can apply a
function to the keyed in data
SELECT item_number FROM item WHERE item_code = lower('M1234');
(2) If you can not ensure data case then you can apply the function to
both side