SQLite LIKE operator

The SQLite LIKE operator enables searches for pattern matches. This operator works in combination with SQLite SELECT queries, using the SQLite WHERE clause.

See the example below:

SELECT

                name

FROM

                drivers

WHERE

                car LIKE ‘Ford%’;

Above SQLite SELECT query returns the names of all drivers that drive a Ford.