Postgres LIKE is case-sensitive -- use ILIKE

PostgreSQL LIKE comparison is case-sensitive. WHERE name LIKE '%john%' does not match 'John' or 'JOHN'. MySQL LIKE is case-insensitive by default, causing confusion when switching databases.

PostgreSQL: use ILIKE for case-insensitive pattern matching. Or use lower(): WHERE lower(name) LIKE lower('%john%'). For better performance: create a functional index on lower(name). Alternatively: use citext extension for case-insensitive text columns. MySQL developers switching to PostgreSQL are most often caught by this.

PostgreSQL follows the SQL standard where LIKE is case-sensitive. MySQL default collation (utf8_general_ci) makes LIKE case-insensitive, which is non-standard.