{"id":174149,"date":"2023-11-27T16:49:00","date_gmt":"2023-11-27T15:49:00","guid":{"rendered":"https:\/\/datascientest.com\/en\/?p=174149"},"modified":"2023-11-27T16:52:52","modified_gmt":"2023-11-27T15:52:52","slug":"sql-where-heres-the-syntax","status":"publish","type":"post","link":"https:\/\/datascientest.com\/en\/sql-where-heres-the-syntax","title":{"rendered":"SQL WHERE: Here&#8217;s the syntax"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"174149\" class=\"elementor elementor-174149\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-a91844c e-flex e-con-boxed e-con\" data-id=\"a91844c\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-4f50f25 elementor-widget elementor-widget-heading\" data-id=\"4f50f25\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading-title[class*=elementor-size-]>a{color:inherit;font-size:inherit;line-height:inherit}.elementor-widget-heading .elementor-heading-title.elementor-size-small{font-size:15px}.elementor-widget-heading .elementor-heading-title.elementor-size-medium{font-size:19px}.elementor-widget-heading .elementor-heading-title.elementor-size-large{font-size:29px}.elementor-widget-heading .elementor-heading-title.elementor-size-xl{font-size:39px}.elementor-widget-heading .elementor-heading-title.elementor-size-xxl{font-size:59px}<\/style><h2 class=\"elementor-heading-title elementor-size-default\">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 <a href=\"https:\/\/datascientest.com\/formation-sql\">SQL<\/a>, its use cases and its comparison operators to carry out your queries more efficiently.<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-1bcb513 e-flex e-con-boxed e-con\" data-id=\"1bcb513\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-2259c32 elementor-widget elementor-widget-heading\" data-id=\"2259c32\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">The syntax of the WHERE command in SQL<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a790f09 elementor-widget elementor-widget-text-editor\" data-id=\"a790f09\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#69727d;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#69727d;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<p>The WHERE command consists of a SELECT command and the WHERE condition.<\/p><p>The most common syntax is as follows:<\/p><p>SELECT column_name1, column_name2 FROM table_name WHERE a_condition<\/p><p>Let&#8217;s break down this SQL query:<\/p><p>SELECT will select the columns named column_name1 and column_name2<br \/>FROM will select the table named table_name<br \/>WHERE adds a condition: select only what respects the condition une_condition.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-b2a28a8 e-flex e-con-boxed e-con\" data-id=\"b2a28a8\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-5f91cbe elementor-widget elementor-widget-heading\" data-id=\"5f91cbe\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Some examples of WHERE commands<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-18cf685 elementor-widget elementor-widget-text-editor\" data-id=\"18cf685\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>To make the WHERE command more concrete and better understand how it works, let&#8217;s apply it to a specific case. In this example, we&#8217;re using a customer table. It simulates a table containing a company&#8217;s customers and their number of orders.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9d7e6db elementor-widget__width-initial elementor-widget elementor-widget-html\" data-id=\"9d7e6db\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style type=\"text\/css\">\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<\/style>\n<table class=\"tg\">\n<thead>\n  <tr>\n    <th class=\"tg-9fd4\">ID<\/th>\n    <th class=\"tg-9fd4\">First Name<\/th>\n    <th class=\"tg-9fd4\">Last Name<\/th>\n    <th class=\"tg-9fd4\">Email<\/th>\n    <th class=\"tg-9fd4\">Order Count<\/th>\n    <th class=\"tg-9fd4\">City<\/th>\n  <\/tr>\n<\/thead>\n<tbody>\n  <tr>\n    <td class=\"tg-9fd4\">1<\/td>\n    <td class=\"tg-0lax\">Marie <\/td>\n    <td class=\"tg-0lax\">Nevier<\/td>\n    <td class=\"tg-0lax\">mnevier@example.com<\/td>\n    <td class=\"tg-0lax\">7<\/td>\n    <td class=\"tg-0lax\">Paris<\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-9fd4\">2<\/td>\n    <td class=\"tg-0lax\">Ga\u00ebtan<\/td>\n    <td class=\"tg-0lax\">Doucle<\/td>\n    <td class=\"tg-0lax\">gdoucle@example.com<\/td>\n    <td class=\"tg-0lax\">4<\/td>\n    <td class=\"tg-0lax\">Nantes<\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-9fd4\">3<\/td>\n    <td class=\"tg-0lax\">Louis<\/td>\n    <td class=\"tg-0lax\">Chenard<\/td>\n    <td class=\"tg-0lax\">lchenard@example.com<\/td>\n    <td class=\"tg-0lax\">1<\/td>\n    <td class=\"tg-0lax\">Lyon<\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-9fd4\">4<\/td>\n    <td class=\"tg-0lax\">Olivia<\/td>\n    <td class=\"tg-0lax\">Caffin<\/td>\n    <td class=\"tg-0lax\">ocaffin@example.com<\/td>\n    <td class=\"tg-0lax\">9<\/td>\n    <td class=\"tg-0lax\">Bordeaux<\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-9fd4\">5<\/td>\n    <td class=\"tg-0lax\">Camille<\/td>\n    <td class=\"tg-0lax\">Loutran<\/td>\n    <td class=\"tg-0lax\">cloutran@example.com<\/td>\n    <td class=\"tg-0lax\">3<\/td>\n    <td class=\"tg-0lax\">Paris<\/td>\n  <\/tr>\n<\/tbody>\n<\/table>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-affc025 elementor-widget elementor-widget-heading\" data-id=\"affc025\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Example of selection by city<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-60ee3ca elementor-widget elementor-widget-text-editor\" data-id=\"60ee3ca\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>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&#8217;d run the query :<\/p><p>SELECT * FROM customers WHERE city = &#8216;Paris&#8217;.<\/p><p>This query returns the following selection:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-287c49c elementor-widget__width-initial elementor-widget elementor-widget-html\" data-id=\"287c49c\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style type=\"text\/css\">\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<\/style>\n<table class=\"tg\">\n<thead>\n  <tr>\n    <th class=\"tg-pu0z\">ID<\/th>\n    <th class=\"tg-pu0z\">First Name<\/th>\n    <th class=\"tg-pu0z\">Last Name<\/th>\n    <th class=\"tg-pu0z\">Email<\/th>\n    <th class=\"tg-pu0z\">Order Count<\/th>\n    <th class=\"tg-pu0z\">City<\/th>\n  <\/tr>\n<\/thead>\n<tbody>\n  <tr>\n    <td class=\"tg-pu0z\">1<\/td>\n    <td class=\"tg-0pky\">Marie<\/td>\n    <td class=\"tg-0pky\">Nevier<\/td>\n    <td class=\"tg-0pky\">mnevier@example.com<\/td>\n    <td class=\"tg-0pky\">7<\/td>\n    <td class=\"tg-0pky\">Paris<\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-pu0z\">2<\/td>\n    <td class=\"tg-0pky\">Camille<\/td>\n    <td class=\"tg-0pky\">Loutran<\/td>\n    <td class=\"tg-0pky\">cloutran@example.com<\/td>\n    <td class=\"tg-0pky\">3<\/td>\n    <td class=\"tg-0pky\">Paris<\/td>\n  <\/tr>\n<\/tbody>\n<\/table>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-262708d elementor-widget elementor-widget-text-editor\" data-id=\"262708d\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>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&#8217;d run the query :<\/p><p>SELECT * FROM customers WHERE city = &#8216;Paris&#8217;.<\/p><p>This query returns the following selection:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c622e39 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"c622e39\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/en\/data-scientist-course\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Learn how to use SQL<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-946064e elementor-widget elementor-widget-heading\" data-id=\"946064e\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Example of selection by number of orders<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b4bba7c elementor-widget elementor-widget-text-editor\" data-id=\"b4bba7c\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>For a physical or online business, it can be useful to filter customers by number of orders. Let&#8217;s take the initial table and run the following query:<\/p><p>SELECT * FROM customers WHERE nbr_orders &gt;= 4<\/p><p>This query returns all customers who have placed 4 or more orders:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-42e408c elementor-widget__width-initial elementor-widget elementor-widget-html\" data-id=\"42e408c\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style type=\"text\/css\">\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<\/style>\n<table class=\"tg\">\n<thead>\n  <tr>\n    <th class=\"tg-9fd4\">ID<\/th>\n    <th class=\"tg-9fd4\">First Name<\/th>\n    <th class=\"tg-9fd4\">Last Name<\/th>\n    <th class=\"tg-9fd4\">Email<\/th>\n    <th class=\"tg-9fd4\">Order Count<\/th>\n    <th class=\"tg-9fd4\">City<\/th>\n  <\/tr>\n<\/thead>\n<tbody>\n  <tr>\n    <td class=\"tg-9fd4\">1<\/td>\n    <td class=\"tg-0lax\">Marie<\/td>\n    <td class=\"tg-0lax\">Nevier<\/td>\n    <td class=\"tg-0lax\">mnevier@example.com<\/td>\n    <td class=\"tg-0lax\">7<\/td>\n    <td class=\"tg-0lax\">Paris<\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-9fd4\">2<\/td>\n    <td class=\"tg-0lax\">Ga\u00ebtan<\/td>\n    <td class=\"tg-0lax\">Doucle<\/td>\n    <td class=\"tg-0lax\">gdoucle@example.com<\/td>\n    <td class=\"tg-0lax\">4<\/td>\n    <td class=\"tg-0lax\">Nantes<\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-9fd4\">3<\/td>\n    <td class=\"tg-0lax\">Olivia<\/td>\n    <td class=\"tg-0lax\">Caffin<\/td>\n    <td class=\"tg-0lax\">ocaffin@example.com<\/td>\n    <td class=\"tg-0lax\">9<\/td>\n    <td class=\"tg-0lax\">Bordeaux<\/td>\n  <\/tr>\n<\/tbody>\n<\/table>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-5420238 e-flex e-con-boxed e-con\" data-id=\"5420238\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-c754a5c elementor-widget elementor-widget-heading\" data-id=\"c754a5c\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Comparison operators in the WHERE command<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3251395 elementor-widget elementor-widget-text-editor\" data-id=\"3251395\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>In our two examples, we&#8217;ve used the = and &gt;= 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\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a7e576a elementor-widget__width-initial elementor-widget elementor-widget-html\" data-id=\"a7e576a\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style type=\"text\/css\">\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<\/style>\n<table class=\"tg\">\n<thead>\n  <tr>\n    <th class=\"tg-52qd\">Operator<\/th>\n    <th class=\"tg-52qd\">Operator Description<\/th>\n  <\/tr>\n<\/thead>\n<tbody>\n  <tr>\n    <td class=\"tg-0lax\"><span style=\"font-weight:400;font-style:normal;text-decoration:none;color:#000;background-color:transparent\">=<\/span><\/td>\n    <td class=\"tg-0lax\"><span style=\"font-weight:400;font-style:normal;text-decoration:none;color:#000;background-color:transparent\">Equal<\/span><\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-0lax\"><span style=\"font-weight:400;font-style:normal;text-decoration:none;color:#000;background-color:transparent\">&lt;&gt; or !=<\/span><\/td>\n    <td class=\"tg-0lax\"><span style=\"font-weight:400;font-style:normal;text-decoration:none;color:#000;background-color:transparent\">Not Equal<\/span><\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-0lax\"><span style=\"font-weight:400;font-style:normal;text-decoration:none;color:#000;background-color:transparent\">&lt;<\/span><\/td>\n    <td class=\"tg-0lax\"><span style=\"font-weight:400;font-style:normal;text-decoration:none;color:#000;background-color:transparent\">Less Than<\/span><\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-0lax\"><span style=\"font-weight:400;font-style:normal;text-decoration:none;color:#000;background-color:transparent\">&gt;<\/span><\/td>\n    <td class=\"tg-0lax\"><span style=\"font-weight:400;font-style:normal;text-decoration:none;color:#000;background-color:transparent\">Greater Than<\/span><\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-0lax\"><span style=\"font-weight:400;font-style:normal;text-decoration:none;color:#000;background-color:transparent\">&lt;=<\/span><\/td>\n    <td class=\"tg-0lax\"><span style=\"font-weight:400;font-style:normal;text-decoration:none;color:#000;background-color:transparent\">Less Than or Equal<\/span><\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-0lax\"><span style=\"font-weight:400;font-style:normal;text-decoration:none;color:#000;background-color:transparent\">&gt;=<\/span><\/td>\n    <td class=\"tg-0lax\"><span style=\"font-weight:400;font-style:normal;text-decoration:none;color:#000;background-color:transparent\">Greater Than or Equal<\/span><\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-0lax\"><span style=\"font-weight:400;font-style:normal;text-decoration:none;color:#000;background-color:transparent\">IN<\/span><\/td>\n    <td class=\"tg-0lax\"><span style=\"font-weight:400;font-style:normal;text-decoration:none;color:#000;background-color:transparent\">List of Possible Values<\/span><\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-0lax\"><span style=\"font-weight:400;font-style:normal;text-decoration:none;color:#000;background-color:transparent\">BETWEEN<\/span><\/td>\n    <td class=\"tg-0lax\"><span style=\"font-weight:400;font-style:normal;text-decoration:none;color:#000;background-color:transparent\">Values within a Data Range (value range or date range)<\/span><\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-0lax\"><span style=\"font-weight:400;font-style:normal;text-decoration:none;color:#000;background-color:transparent\">LIKE<\/span><\/td>\n    <td class=\"tg-0lax\"><span style=\"font-weight:400;font-style:normal;text-decoration:none;color:#000;background-color:transparent\">Matches the beginning, middle, or end of a word<\/span><\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-0lax\"><span style=\"font-weight:400;font-style:normal;text-decoration:none;color:#000;background-color:transparent\">IS NULL<\/span><\/td>\n    <td class=\"tg-0lax\"><span style=\"font-weight:400;font-style:normal;text-decoration:none;color:#000;background-color:transparent\">Value is Null<\/span><\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-0lax\"><span style=\"font-weight:400;font-style:normal;text-decoration:none;color:#000;background-color:transparent\">IS NOT NULL<\/span><\/td>\n    <td class=\"tg-0lax\"><span style=\"font-weight:400;font-style:normal;text-decoration:none;color:#000;background-color:transparent\">Value is Not Null<\/span><\/td>\n  <\/tr>\n<\/tbody>\n<\/table>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-c4465c0 e-flex e-con-boxed e-con\" data-id=\"c4465c0\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-052ffb7 elementor-widget elementor-widget-heading\" data-id=\"052ffb7\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Conclusion on SQL WHERE<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-407cca2 elementor-widget elementor-widget-text-editor\" data-id=\"407cca2\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>In short, <strong>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>\u00a0<\/p><p><span data-sheets-formula-bar-text-style=\"font-size:13px;color:#000000;font-weight:normal;text-decoration:none;font-family:'Arial';font-style:normal;text-decoration-skip-ink:none;\">\ud83d\udca1<\/span>Related articles:<\/p><table dir=\"ltr\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\" data-sheets-root=\"1\"><colgroup><col width=\"656\" \/><\/colgroup><tbody><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;SQL Developer: What is it? What's it for?&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/sql-developer-what-is-it-whats-it-for\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/sql-developer-what-is-it-whats-it-for\" target=\"_blank\" rel=\"noopener\">SQL Developer: What is it? What&#8217;s it for?<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;SQL Tutorial: Top 5 Most Useful Methods&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/sql-tutorial-top-5-most-useful-methods\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/sql-tutorial-top-5-most-useful-methods\" target=\"_blank\" rel=\"noopener\">SQL Tutorial: Top 5 Most Useful Methods<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;SQL joins: everything you need to know about table associations&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/sql-joins-everything-you-need-to-know-about\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/sql-joins-everything-you-need-to-know-about\" target=\"_blank\" rel=\"noopener\">SQL joins: everything you need to know about table associations<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;SQL vs NoSQL: differences, uses, advantages and disadvantages&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/sql-vs-nosql\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/sql-vs-nosql\" target=\"_blank\" rel=\"noopener\">SQL vs NoSQL: differences, uses, advantages and disadvantages<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;NoSQL: All about non-relational databases&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/all-about-non-relational-databases\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/all-about-non-relational-databases\" target=\"_blank\" rel=\"noopener\">NoSQL: All about non-relational databases<\/a><\/td><\/tr><\/tbody><\/table>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-873d3b8 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"873d3b8\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/en\/data-scientist-course\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Master SQL with DataScientest<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-bc3a8e1 e-flex e-con-boxed e-con\" data-id=\"bc3a8e1\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-930eb21 elementor-widget elementor-widget-html\" data-id=\"930eb21\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<script type=\"application\/ld+json\">\n{\n  \"@context\": \"https:\/\/schema.org\",\n  \"@type\": \"FAQPage\",\n  \"mainEntity\": [{\n    \"@type\": \"Question\",\n    \"name\": \"The syntax of the WHERE command in SQL\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"The WHERE command consists of a SELECT command and the WHERE condition. The most common syntax is as follows: SELECT column_name1, column_name2 FROM table_name WHERE a_condition\".\n    }\n  },{\n    \"@type\": \"Question\",\n    \"name\": \"The comparison operators of the WHERE command\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"In both our examples, we've used the = and >= operators to filter the results in the SQL query. But these are not the only operators applicable with the WHERE command.\"\n    }\n  }]\n}\n<\/script>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>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 [&hellip;]<\/p>\n","protected":false},"author":67,"featured_media":174150,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"content-type":"","inline_featured_image":false},"categories":[2425],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v21.7) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SQL WHERE: Here&#039;s the syntax<\/title>\n<meta name=\"description\" content=\"The SQL WHERE clause is used to filter records from a database table based on a specified condition. Here&#039;s the basic syntax:\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/datascientest.com\/en\/sql-where-heres-the-syntax\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL WHERE: Here&#039;s the syntax\" \/>\n<meta property=\"og:description\" content=\"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\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/en\/sql-where-heres-the-syntax\" \/>\n<meta property=\"og:site_name\" content=\"Data Science Courses | DataScientest\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataScientestEN\" \/>\n<meta property=\"article:published_time\" content=\"2023-11-27T15:49:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-27T15:52:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/en\/files\/2023\/11\/sql-where-1024x512-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1024\" \/>\n\t<meta property=\"og:image:height\" content=\"512\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Melanie\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataScientest__\" \/>\n<meta name=\"twitter:site\" content=\"@DataScientest__\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Melanie\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/datascientest.com\/en\/sql-where-heres-the-syntax#article\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/en\/sql-where-heres-the-syntax\"},\"author\":{\"name\":\"Melanie\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d\"},\"headline\":\"SQL WHERE: Here&#8217;s the syntax\",\"datePublished\":\"2023-11-27T15:49:00+00:00\",\"dateModified\":\"2023-11-27T15:52:52+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/datascientest.com\/en\/sql-where-heres-the-syntax\"},\"wordCount\":650,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/datascientest.com\/en\/#organization\"},\"articleSection\":[\"Data Science\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/datascientest.com\/en\/sql-where-heres-the-syntax#respond\"]}],\"copyrightYear\":\"2023\",\"copyrightHolder\":{\"@id\":\"https:\/\/datascientest.com\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/en\/sql-where-heres-the-syntax\",\"url\":\"https:\/\/datascientest.com\/en\/sql-where-heres-the-syntax\",\"name\":\"SQL WHERE: Here's the syntax\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/en\/#website\"},\"datePublished\":\"2023-11-27T15:49:00+00:00\",\"dateModified\":\"2023-11-27T15:52:52+00:00\",\"description\":\"The SQL WHERE clause is used to filter records from a database table based on a specified condition. Here's the basic syntax:\",\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/en\/sql-where-heres-the-syntax\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/datascientest.com\/en\/#website\",\"url\":\"https:\/\/datascientest.com\/en\/\",\"name\":\"Data Science Courses | DataScientest\",\"description\":\"Leader in Data Science Courses\",\"publisher\":{\"@id\":\"https:\/\/datascientest.com\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/datascientest.com\/en\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/datascientest.com\/en\/#organization\",\"name\":\"DataScientest\",\"url\":\"https:\/\/datascientest.com\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png\",\"contentUrl\":\"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png\",\"width\":301,\"height\":301,\"caption\":\"DataScientest\"},\"image\":{\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/DataScientestEN\",\"https:\/\/twitter.com\/DataScientest__\",\"https:\/\/www.linkedin.com\/school\/datascientest\/mycompany\/\",\"https:\/\/www.tiktok.com\/@datascientest\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d\",\"name\":\"Melanie\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g\",\"caption\":\"Melanie\"},\"url\":\"https:\/\/datascientest.com\/en\/author\/melaniekrause\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL WHERE: Here's the syntax","description":"The SQL WHERE clause is used to filter records from a database table based on a specified condition. Here's the basic syntax:","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/datascientest.com\/en\/sql-where-heres-the-syntax","og_locale":"en_GB","og_type":"article","og_title":"SQL WHERE: Here's the syntax","og_description":"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","og_url":"https:\/\/datascientest.com\/en\/sql-where-heres-the-syntax","og_site_name":"Data Science Courses | DataScientest","article_publisher":"https:\/\/www.facebook.com\/DataScientestEN","article_published_time":"2023-11-27T15:49:00+00:00","article_modified_time":"2023-11-27T15:52:52+00:00","og_image":[{"width":1024,"height":512,"url":"https:\/\/datascientest.com\/en\/files\/2023\/11\/sql-where-1024x512-1.png","type":"image\/png"}],"author":"Melanie","twitter_card":"summary_large_image","twitter_creator":"@DataScientest__","twitter_site":"@DataScientest__","twitter_misc":{"Written by":"Melanie","Estimated reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/datascientest.com\/en\/sql-where-heres-the-syntax#article","isPartOf":{"@id":"https:\/\/datascientest.com\/en\/sql-where-heres-the-syntax"},"author":{"name":"Melanie","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d"},"headline":"SQL WHERE: Here&#8217;s the syntax","datePublished":"2023-11-27T15:49:00+00:00","dateModified":"2023-11-27T15:52:52+00:00","mainEntityOfPage":{"@id":"https:\/\/datascientest.com\/en\/sql-where-heres-the-syntax"},"wordCount":650,"commentCount":0,"publisher":{"@id":"https:\/\/datascientest.com\/en\/#organization"},"articleSection":["Data Science"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/datascientest.com\/en\/sql-where-heres-the-syntax#respond"]}],"copyrightYear":"2023","copyrightHolder":{"@id":"https:\/\/datascientest.com\/#organization"}},{"@type":"WebPage","@id":"https:\/\/datascientest.com\/en\/sql-where-heres-the-syntax","url":"https:\/\/datascientest.com\/en\/sql-where-heres-the-syntax","name":"SQL WHERE: Here's the syntax","isPartOf":{"@id":"https:\/\/datascientest.com\/en\/#website"},"datePublished":"2023-11-27T15:49:00+00:00","dateModified":"2023-11-27T15:52:52+00:00","description":"The SQL WHERE clause is used to filter records from a database table based on a specified condition. Here's the basic syntax:","inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/en\/sql-where-heres-the-syntax"]}]},{"@type":"WebSite","@id":"https:\/\/datascientest.com\/en\/#website","url":"https:\/\/datascientest.com\/en\/","name":"Data Science Courses | DataScientest","description":"Leader in Data Science Courses","publisher":{"@id":"https:\/\/datascientest.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/datascientest.com\/en\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/datascientest.com\/en\/#organization","name":"DataScientest","url":"https:\/\/datascientest.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png","contentUrl":"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png","width":301,"height":301,"caption":"DataScientest"},"image":{"@id":"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataScientestEN","https:\/\/twitter.com\/DataScientest__","https:\/\/www.linkedin.com\/school\/datascientest\/mycompany\/","https:\/\/www.tiktok.com\/@datascientest"]},{"@type":"Person","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d","name":"Melanie","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g","caption":"Melanie"},"url":"https:\/\/datascientest.com\/en\/author\/melaniekrause"}]}},"_links":{"self":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts\/174149"}],"collection":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/users\/67"}],"replies":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/comments?post=174149"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts\/174149\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/media\/174150"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/media?parent=174149"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/categories?post=174149"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/tags?post=174149"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}