Subject | php case insensitive field access |
---|---|
Author | jackdmason |
Post date | 2013-01-23T20:59:47Z |
Using the php interface is there a way to specify in the query the data fields are to be case insensitive such that a query such as:
SELECT * FROM CUST WHERE LASTNAME LIKE 'mcg%' AND FIRSTNAME LIKE 'jo%'
will find Josh Mcgee, josh McGee, Joe McGrath, john mcGregor, etc.?
SELECT * FROM CUST WHERE LASTNAME LIKE 'mcg%' AND FIRSTNAME LIKE 'jo%'
will find Josh Mcgee, josh McGee, Joe McGrath, john mcGregor, etc.?