ProAnswers.org

What is 'LIKE' used for in WHERE clause?

What is ‘LIKE’ used for in WHERE clause?

LIKE is another keyword that is used in the WHERE clause. Basically, LIKE allows you to do a search based on a pattern rather than specifying exactly what is desired (as in IN) or spell out a range (as in BETWEEN).

The syntax for is as follows:

SELECT "column_name" FROM "table_name" WHERE "column_name" LIKE {PATTERN}