Query Case In-sensitive
| From: | Larry Sandwick | Date: | Mon, 17 Nov 2003 19:53:24 +0000 |
| Subject: | Query Case In-sensitive | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-31590@lists.php.net to get a copy of this message | ||
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