ILIKE
An operator, available only in PostgreSQL, that works like LIKE but ignores upper and lower case.
In more detail
SQLite does not have it. The portable alternative is to lower-case both sides before comparing with LIKE.
Example
WHERE name ILIKE '%cable%'Related terms
- LIKE — An operator that matches text against a pattern, where % stands for any run of characters and _ for exactly one.
- PostgreSQL — A widely used open source relational database server with strict typing, rich data types and extensions.
Taught in
- Filtering With The WHERE Clause — PostgreSQL, Indexing & Relational Data Modeling