LIKE

An operator that matches text against a pattern, where % stands for any run of characters and _ for exactly one.

In more detail

In SQLite, LIKE ignores the case of plain English letters by default; in PostgreSQL it is case-sensitive. For portable case-insensitive matching, compare lower(name) with a lower-case pattern.

Example

WHERE name LIKE '%cable%'

Related terms

Taught in

References