Code has been added to clipboard!

SQL WHERE – the Filtering Clause and Its Operators

Reading time 1 min
Published Jan 6, 2016
Updated Oct 3, 2019

SQL WHERE: Main Tips

  • The WHERE clause is applied to sort just those records that correspond the condition.
  • It is applied in SELECT, UPDATE, DELETE statements.

SQL WHERE Syntax

Example
SELECT column1, column2, ...
FROM table_name
WHERE condition;
Theory is great, but we recommend digging deeper!

WHERE Clause Operators

Operator Description
= Equal
<> or != Not equal
> Greater than
< Less than
>= Equal or greater than
<= Equal or Less than
BETWEEN Between a certain range
LIKE Search for a specific pattern
IN To define multiple possible column values

Demo Database

This is a demo database used for examples of this post:

ID Name City Country
1 Tom Kurkutis New York USA
2 Ana Fernandez London UK
3 Antonio Indigo Paris France
4 Aarav Kaelin Delhi India
5 Andrew Tumota Miami USA
6 Basma Zlata Miami USA

Examples for Using SQL WHERE

The following example selects all the developers from the country 'France' in the Developers table:

Example
SELECT * FROM Developers
WHERE Country='France';

This example shows that numeric fields do not require quotes:

Example
SELECT * FROM Developers
WHERE ID=1;