WHERE Clause

The WHERE clause specifies any filters to apply to the data. This allows you to select only a subset of the data in which you are interested. Logically the WHERE clause is applied immediately after the FROM clause.

Examples

Select all rows where the id is equal to 3:

SELECT *
FROM tbl
WHERE id = 3;

Select all rows that match the given case-sensitive LIKE expression:

SELECT *
FROM tbl
WHERE name LIKE '%mark%';

Select all rows that match the given case-insensitive expression formulated with the ILIKE operator:

SELECT *
FROM tbl
WHERE name ILIKE '%mark%';

Select all rows that match the given composite expression:

SELECT *
FROM tbl
WHERE id = 3 OR id = 7;

Syntax