SQL WHERE Clause
Last updated
Was this helpful?
Last updated
Was this helpful?
The WHERE clause is used to filter records.
The WHERE clause is used to extract only those records that fulfill a specified condition.
Note: The WHERE clause is not only used in SELECT statement, it is also used in UPDATE, DELETE statement, etc.!
Demo Database
Below is a selection from the "Customers" table in a sample database:
The following SQL statement selects all the customers from the country "Mexico", in the "Customers" table:
Text Fields vs. Numeric Fields
SQL requires single quotes around text values (most database systems will also allow double quotes).
However, numeric fields should not be enclosed in quotes:Example
The following operators can be used in the WHERE clause: