[PHP-DB] Query Case In-sensitive

[Larry Sandwick]

Is there a way to run a query so that it ignores the case, and the query
is not case sensitive?

Advertising

 

 

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