{"id":174149,"date":"2023-11-27T16:49:00","date_gmt":"2023-11-27T15:49:00","guid":{"rendered":"https:\/\/liora.io\/en\/?p=174149"},"modified":"2026-02-06T08:44:42","modified_gmt":"2026-02-06T07:44:42","slug":"sql-where-heres-the-syntax","status":"publish","type":"post","link":"https:\/\/liora.io\/en\/sql-where-heres-the-syntax","title":{"rendered":"SQL WHERE: Here’s the syntax"},"content":{"rendered":"

The WHERE command in SQL is used in queries to filter out data that meets a specific condition. This allows you to extract only the desired rows from a table in a database. With this command, you can select a subset of data according to precise criteria. Find out more about the syntax of the WHERE command in SQL<\/a>, its use cases and its comparison operators to carry out your queries more efficiently.<\/strong><\/p>\t\t\n\t\t\t

The syntax of the WHERE command in SQL<\/h3>\t\t\n\t\t

The WHERE command consists of a SELECT command and the WHERE condition.<\/p>

The most common syntax is as follows:<\/p>

SELECT column_name1, column_name2 FROM table_name WHERE a_condition<\/p>

Let’s break down this SQL query:<\/p>

SELECT will select the columns named column_name1 and column_name2
FROM will select the table named table_name
WHERE adds a condition: select only what respects the condition une_condition.<\/p>\t\t\n\t\t\t

Some examples of WHERE commands<\/h3>\t\t\n\t\t

To make the WHERE command more concrete and better understand how it works, let’s apply it to a specific case. In this example, we’re using a customer table. It simulates a table containing a company’s customers and their number of orders.<\/p>\t\t\n\t\t\t\n.tg {border-collapse:collapse;border-spacing:0;}\n.tg td{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\n overflow:hidden;padding:10px 5px;word-break:normal;}\n.tg th{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\n font-weight:normal;overflow:hidden;padding:10px 5px;word-break:normal;}\n.tg .tg-9fd4{background-color:#9b9b9b;font-weight:bold;text-align:left;vertical-align:top}\n.tg .tg-0lax{text-align:left;vertical-align:top}\n\n\n\n \n \n \n \n \n \n \n
ID<\/th>\n First Name<\/th>\n Last Name<\/th>\n Email<\/th>\n Order Count<\/th>\n City<\/th>\n <\/tr>\n<\/thead>\n
1<\/td>\n Marie <\/td>\n Nevier<\/td>\n mnevier@example.com<\/td>\n 7<\/td>\n Paris<\/td>\n <\/tr>\n
2<\/td>\n Ga\u00ebtan<\/td>\n Doucle<\/td>\n gdoucle@example.com<\/td>\n 4<\/td>\n Nantes<\/td>\n <\/tr>\n
3<\/td>\n Louis<\/td>\n Chenard<\/td>\n lchenard@example.com<\/td>\n 1<\/td>\n Lyon<\/td>\n <\/tr>\n
4<\/td>\n Olivia<\/td>\n Caffin<\/td>\n ocaffin@example.com<\/td>\n 9<\/td>\n Bordeaux<\/td>\n <\/tr>\n
5<\/td>\n Camille<\/td>\n Loutran<\/td>\n cloutran@example.com<\/td>\n 3<\/td>\n Paris<\/td>\n <\/tr>\n<\/tbody>\n<\/table>\n\t\t\t

Example of selection by city<\/h4>\t\t\n\t\t

By using the syntax of the WHERE command and adding the right elements, you can filter this table as you see fit. For example, to select only customers from the city of Paris, we’d run the query :<\/p>

SELECT * FROM customers WHERE city = ‘Paris’.<\/p>

This query returns the following selection:<\/p>\t\t\n\t\t\t\n.tg {border-collapse:collapse;border-spacing:0;}\n.tg td{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\n overflow:hidden;padding:10px 5px;word-break:normal;}\n.tg th{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\n font-weight:normal;overflow:hidden;padding:10px 5px;word-break:normal;}\n.tg .tg-pu0z{background-color:#9b9b9b;border-color:inherit;font-weight:bold;text-align:left;vertical-align:top}\n.tg .tg-0pky{border-color:inherit;text-align:left;vertical-align:top}\n\n\n\n \n \n \n \n
ID<\/th>\n First Name<\/th>\n Last Name<\/th>\n Email<\/th>\n Order Count<\/th>\n City<\/th>\n <\/tr>\n<\/thead>\n
1<\/td>\n Marie<\/td>\n Nevier<\/td>\n mnevier@example.com<\/td>\n 7<\/td>\n Paris<\/td>\n <\/tr>\n
2<\/td>\n Camille<\/td>\n Loutran<\/td>\n cloutran@example.com<\/td>\n 3<\/td>\n Paris<\/td>\n <\/tr>\n<\/tbody>\n<\/table>\t\t\n\t\t

By using the syntax of the WHERE command and adding the right elements, you can filter this table as you see fit. For example, to select only customers from the city of Paris, we’d run the query :<\/p>

SELECT * FROM customers WHERE city = ‘Paris’.<\/p>

This query returns the following selection:<\/p>\t\t\n\t\t\t\n

Learn how to use SQL<\/a><\/div><\/div>\n\n\t\t\t

Example of selection by number of orders<\/h4>\t\t\n\t\t

For a physical or online business, it can be useful to filter customers by number of orders. Let’s take the initial table and run the following query:<\/p>

SELECT * FROM customers WHERE nbr_orders >= 4<\/p>

This query returns all customers who have placed 4 or more orders:<\/p>\t\t\n\t\t\t\n.tg {border-collapse:collapse;border-spacing:0;}\n.tg td{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\n overflow:hidden;padding:10px 5px;word-break:normal;}\n.tg th{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\n font-weight:normal;overflow:hidden;padding:10px 5px;word-break:normal;}\n.tg .tg-9fd4{background-color:#9b9b9b;font-weight:bold;text-align:left;vertical-align:top}\n.tg .tg-0lax{text-align:left;vertical-align:top}\n\n\n\n \n \n \n \n \n
ID<\/th>\n First Name<\/th>\n Last Name<\/th>\n Email<\/th>\n Order Count<\/th>\n City<\/th>\n <\/tr>\n<\/thead>\n
1<\/td>\n Marie<\/td>\n Nevier<\/td>\n mnevier@example.com<\/td>\n 7<\/td>\n Paris<\/td>\n <\/tr>\n
2<\/td>\n Ga\u00ebtan<\/td>\n Doucle<\/td>\n gdoucle@example.com<\/td>\n 4<\/td>\n Nantes<\/td>\n <\/tr>\n
3<\/td>\n Olivia<\/td>\n Caffin<\/td>\n ocaffin@example.com<\/td>\n 9<\/td>\n Bordeaux<\/td>\n <\/tr>\n<\/tbody>\n<\/table>\n\t\t\t

Comparison operators in the WHERE command<\/h3>\t\t\n\t\t

In our two examples, we’ve used the = and >= operators to filter the results in the SQL query. But these are not the only operators that can be used with the WHERE command. See the table below for a list of the most commonly used operators:<\/p>\t\t\n\t\t\t\n.tg {border-collapse:collapse;border-spacing:0;}\n.tg td{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\n overflow:hidden;padding:10px 5px;word-break:normal;}\n.tg th{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\n font-weight:normal;overflow:hidden;padding:10px 5px;word-break:normal;}\n.tg .tg-52qd{background-color:#6665cd;font-size:18px;font-weight:bold;text-align:left;vertical-align:top}\n.tg .tg-0lax{text-align:left;vertical-align:top}\n\n\n\n \n \n \n \n \n \n \n \n \n \n \n \n \n
Operator<\/th>\n Operator Description<\/th>\n <\/tr>\n<\/thead>\n
=<\/td>\n Equal<\/td>\n <\/tr>\n
<> or !=<\/td>\n Not Equal<\/td>\n <\/tr>\n
<<\/td>\n Less Than<\/td>\n <\/tr>\n
><\/td>\n Greater Than<\/td>\n <\/tr>\n
<=<\/td>\n Less Than or Equal<\/td>\n <\/tr>\n
>=<\/td>\n Greater Than or Equal<\/td>\n <\/tr>\n
IN<\/td>\n List of Possible Values<\/td>\n <\/tr>\n
BETWEEN<\/td>\n Values within a Data Range (value range or date range)<\/td>\n <\/tr>\n
LIKE<\/td>\n Matches the beginning, middle, or end of a word<\/td>\n <\/tr>\n
IS NULL<\/td>\n Value is Null<\/td>\n <\/tr>\n
IS NOT NULL<\/td>\n Value is Not Null<\/td>\n <\/tr>\n<\/tbody>\n<\/table>\n\t\t\t

Conclusion on SQL WHERE<\/h3>\t\t\n\t\t

In short, WHERE is a particularly useful SQL<\/strong> command for selecting the rows of a table that meet a specific condition. The various operators allow you to use the WHERE command to filter different values, such as numbers, dates or words.<\/p>

 <\/p>

?Related articles:<\/p><\/colgroup>
SQL Developer: What is it? What’s it for?<\/a><\/td><\/tr>
SQL Tutorial: Top 5 Most Useful Methods<\/a><\/td><\/tr>
SQL joins: everything you need to know about table associations<\/a><\/td><\/tr>
SQL vs NoSQL: differences, uses, advantages and disadvantages<\/a><\/td><\/tr>
NoSQL: All about non-relational databases<\/a><\/td><\/tr><\/tbody><\/table>\t\t\n\t\t\t\n
Master SQL with Liora<\/a><\/div><\/div>\n","protected":false},"excerpt":{"rendered":"

The WHERE command in SQL is used in queries to filter out data that meets a specific condition. This allows you to extract only the desired rows from a table in a database. With this command, you can select a subset of data according to precise criteria. Find out more about the syntax of the […]<\/p>\n","protected":false},"author":76,"featured_media":174150,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"_acf_changed":false,"editor_notices":[],"footnotes":""},"categories":[2433],"class_list":["post-174149","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data-ai"],"acf":[],"_links":{"self":[{"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/posts\/174149","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/users\/76"}],"replies":[{"embeddable":true,"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/comments?post=174149"}],"version-history":[{"count":1,"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/posts\/174149\/revisions"}],"predecessor-version":[{"id":206209,"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/posts\/174149\/revisions\/206209"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/media\/174150"}],"wp:attachment":[{"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/media?parent=174149"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/categories?post=174149"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}