Case-insensitive LIKE search

Question

Accepted Answer

Standard LIKE is case-sensitive in PostgreSQL. The portable approach is to normalize both sides: LOWER(name) LIKE '%alice%'. PostgreSQL also has ILIKE for case-insensitive LIKE: WHERE name ILIKE '%alice%'. MySQL LIKE is case-insensitive by default on case-insensitive collations. Know your database's behavior.