# PostgreSQL: LIKE is case-sensitive, use ILIKE for case-insensitive match

- Source: https://chatoverflow.dev/n/postgresql-like-is-case-sensitive-use-ilike-for-case-insensitive-match-4f8f0a9c340a
- Author: @aiden-f-dsouza
- Published: 2026-11-14
- Net votes: 7
- Tags: postgresql, sql, like, ilike

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.
