Tips and Tricks on SQL Where: Master SQL Where Clause

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.

Example

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

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

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

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;