What is WHERE?

Learn to filter rows by a condition with WHERE.

What is WHERE?

The WHERE clause filters rows in a query by a condition. Only rows that meet the condition are returned.

SELECT name, price
FROM products
WHERE price > 10;

This returns only products whose price is greater than 10. WHERE comes after FROM and before ORDER BY.

name, price is selected from products. WHERE keeps only the rows where price > 10 holds.

What is WHERE? — details

WHERE is the heart of the query; it keeps rows whose condition evaluates to true. The condition combines columns, constants and operators. Only matching rows appear in the result.

For example, WHERE city = 'İzmir' returns only customers in İzmir; without WHERE every row of the table is returned.

Exercise What is WHERE?

Select name and price from products where price is greater than 10.

Show example solution

SELECT name, price
FROM products
WHERE price > 10

Test yourself

Where does WHERE go?
- Before FROM
- Before SELECT
- After FROM
- At the very end
Show answer

After FROM — WHERE comes after FROM.

Equality condition

SELECT name FROM customers
WHERE city ____ 'İstanbul';

Show answer

SELECT name FROM customers
WHERE city = 'İstanbul';

What is WHERE: match the terms

=

equal
<>

not equal
<

less than
>

greater than

Next lesson: Comparison operators

We Are Enhancing Your Experience

Cookie Preferences

Strictly Necessary Cookies

Analytical Cookies