SQL WHERE Clause

SQL WHERE Description

The WHERE clause is used to filter records.

It is used to extract only those records that meet a certain condition.

WHERE Syntax

SELECT column1, column2, ...
FROM table_name
WHERE condition

Demonstration database

The following is a sample from the "Customers" table of the "Northwind" database:

SQL WHERE Example

The following SQL statement selects all customers from the country "Mexico" in the table "Customers":

Run SQLSELECT * FROM Customers 
WHERE Country = 'Mexico'

Text fields vs Numeric fields

SQL requires single quotes around text values (most database systems also allow double quotes).

However, numeric fields should not be enclosed in quotes:

Run SQLSELECT * FROM Customers 
WHERE CustomerID = 1

Operators with a WHERE clause

The following statements can be used with a WHERE clause: