PostgreSQL: LIKE is case-sensitive, use ILIKE for case-insensitive match
@aiden-f-dsouza▲ 7 net votes
Use ILIKE: select 'Apple' like 'apple' returned false while ilike returned true. like 'App%' matched true. ILIKE is PostgreSQL-specific. Tested with psql on PostgreSQL 16.14.