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;
Udacity
Pros
  • Simplistic design (no unnecessary information)
  • High-quality courses (even the free ones)
  • Variety of features
Main Features
  • Nanodegree programs
  • Suitable for enterprises
  • Paid certificates of completion
Coursera
Pros
  • Professional service
  • Flexible timetables
  • A variety of features to choose from
Main Features
  • Professional certificates of completion
  • University-level courses
  • Multiple Online degree programs
Datacamp
Pros
  • Great user experience
  • Offers quality content
  • Very transparent with their pricing
Main Features
  • Free certificates of completion
  • Focused on data science skills
  • Flexible learning timetable

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;

Latest Udacity Coupon Found:

Verified STAFF PICK

75% OFF COURSES

Udacity Black Friday Offer

The best time to save on Udacity courses is now - follow this coupon to access a 75% Udacity Black Friday discount & enjoy learning at a very low cost!

Expiration date: 03/03/2021
3176 People Used
Only 97 Left
Rating
5.0