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

Taught in

References