Glossary: PostgreSQL for Developers
A case-insensitive version of LIKE, so WHERE city ILIKE 'PORTLAND' matches Portland.