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;