ILIKE

ILIKE is a SQL clause in the PostgreSQL Specific category. PostgreSQL case-insensitive pattern matching (like LIKE but case-insensitive). The syntax is SELECT * FROM table WHERE column ILIKE pattern;. It returns matching rows. A typical example: SELECT * FROM users WHERE name ILIKE 'alice%'; -- Matches Alice, ALICE, alice, etc. -- Equivalent to: SELECT * FROM users WHERE LOWER(name) LIKE 'alice%'; A close relative is SERIAL, which postgreSQL auto-increment type. Creates an INTEGER column with a sequence. Equivalent to AUTO_INCREMENT in MySQL. A close relative is RETURNING, which postgreSQL extension that returns values from INSERT/UPDATE/DELETE statements (like OUTPUT in SQL Server). A close relative is ARRAY, which postgreSQL supports array columns and array operations. Can be multi-dimensional. More about this category: PostgreSQL-specific features — SERIAL, RETURNING, ARRAY, JSONB, UPSERT. Related PostgreSQL Specific entries: SERIAL, RETURNING, ARRAY, JSONB, UPSERT (INSERT ON CONFLICT), BIGSERIAL / SMALLSERIAL, GENERATED AS IDENTITY, COPY.