]; [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 sides.
Ex : Select item number from item where upper(item_code) = upper(m1234
]
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, MySQL, SQL-Server)
- Original Message
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
]
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 from item where item_code = M1234 ;
The query above should return
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.
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
Query
Select item number from item where
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,
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
: 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