SQL 'LIKE' syntax
The easiest way to ensure a case-insensitive LIKE is to use something like one of these:
LOWER(column_name) LIKE LOWER(pattern)UPPER(column_name) LIKE UPPER(pattern)Or you can up-case/down-case the pattern outside the SQL and just use:
LOWER(column_name) LIKE down_cased_patternUPPER(column_name) LIKE up_cased_patternI tend to use LOWER out of habit as lower case is easier to read and hence easier to debug.
This is the job of a Database Abstraction Layer.
PDO does not do what you're looking for but there are a few PHP DALs if you google for them.
PDO does not provide a database abstraction; it doesn't rewrite SQL or emulate missing features. You should use a full-blown abstraction layer if you need that facility.