{"id":189765,"date":"2023-02-13T15:38:26","date_gmt":"2023-02-13T15:38:26","guid":{"rendered":"https:\/\/datascientest.com\/?p=189765"},"modified":"2023-11-09T13:54:06","modified_gmt":"2023-11-09T13:54:06","slug":"sql-where-tout-savoir","status":"publish","type":"post","link":"https:\/\/datascientest.com\/sql-where-tout-savoir","title":{"rendered":"Commande WHERE sur SQL : guide complet"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"189765\" class=\"elementor elementor-189765\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-c99c540 e-flex e-con-boxed e-con\" data-id=\"c99c540\" 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-9e3eebc elementor-widget elementor-widget-heading\" data-id=\"9e3eebc\" 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\">La commande WHERE en SQL est utilis\u00e9e dans les requ\u00eates afin de filtrer les donn\u00e9es qui respectent une condition pr\u00e9cise. Cela permet d\u2019extraire uniquement les lignes d\u00e9sir\u00e9es d\u2019une table dans une base de donn\u00e9es. Avec cette commande, il est possible de s\u00e9lectionner un sous-ensemble de donn\u00e9es en fonction de crit\u00e8res pr\u00e9cis. D\u00e9couvrez en d\u00e9tail la syntaxe de la commande WHERE en <a href=\"https:\/\/datascientest.com\/formation-sql\">SQL<\/a>, ses cas d\u2019utilisation et ses op\u00e9rateurs de comparaisons pour effectuer vos requ\u00eates avec plus d\u2019efficacit\u00e9.<\/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-a579f51 e-flex e-con-boxed e-con\" data-id=\"a579f51\" 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-d99e8dc elementor-widget elementor-widget-heading\" data-id=\"d99e8dc\" 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\">La syntaxe de la commande WHERE en SQL<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-dbd7b1f elementor-widget elementor-widget-text-editor\" data-id=\"dbd7b1f\" 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><span style=\"font-weight: 400;\">La commande WHERE se compose d\u2019une commande SELECT et de la condition WHERE.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">La syntaxe la plus courante est la suivante :<\/span><\/p><pre style=\"padding-left: 40px;\"><span style=\"font-weight: 400;\">SELECT nom_colonne1, nom_colonne2 FROM nom_table WHERE une_condition<\/span><\/pre><p><span style=\"font-weight: 400;\">D\u00e9composons cette <a href=\"https:\/\/datascientest.com\/sql-tout-savoir\">requ\u00eate SQL<\/a> <\/span><span style=\"font-weight: 400;\">:\u00a0<\/span><\/p><ul><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">SELECT va s\u00e9lectionner les colonnes nomm\u00e9es nom_colonne1 et nom_colonne2<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">FROM va s\u00e9lectionner la table nomm\u00e9e nom_table<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">WHERE ajoute une condition : s\u00e9lectionner uniquement ce qui respecte la condition une_condition.\u00a0<\/span><\/li><\/ul>\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-2f490b5 e-flex e-con-boxed e-con\" data-id=\"2f490b5\" 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-db974dd elementor-widget elementor-widget-heading\" data-id=\"db974dd\" 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\">Quelques exemples d\u2019utilisation de la commande WHERE<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f578a8f elementor-widget elementor-widget-text-editor\" data-id=\"f578a8f\" 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><span style=\"font-weight: 400;\">Afin de rendre l\u2019utilisation de la commande WHERE plus concr\u00e8te et mieux comprendre son fonctionnement, appliquons-la \u00e0 un cas pr\u00e9cis. Dans cet exemple, nous utilisons une table <\/span><b>clients<\/b><span style=\"font-weight: 400;\">. Elle simule une table contenant les clients d\u2019une entreprise ainsi que leur nombre de commandes.<\/span><\/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-7517d5f elementor-widget__width-initial elementor-widget elementor-widget-html\" data-id=\"7517d5f\" 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\">\r\n.tg  {border-collapse:collapse;border-spacing:0;}\r\n.tg td{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\r\n  overflow:hidden;padding:10px 5px;word-break:normal;}\r\n.tg th{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\r\n  font-weight:normal;overflow:hidden;padding:10px 5px;word-break:normal;}\r\n.tg .tg-9fd4{background-color:#9b9b9b;font-weight:bold;text-align:left;vertical-align:top}\r\n.tg .tg-0lax{text-align:left;vertical-align:top}\r\n<\/style>\r\n<table class=\"tg\">\r\n<thead>\r\n  <tr>\r\n    <th class=\"tg-9fd4\">id<\/th>\r\n    <th class=\"tg-9fd4\">Pr\u00e9nom<\/th>\r\n    <th class=\"tg-9fd4\">Nom<\/th>\r\n    <th class=\"tg-9fd4\">e-mail<\/th>\r\n    <th class=\"tg-9fd4\">nrb_commandes<\/th>\r\n    <th class=\"tg-9fd4\">Ville<\/th>\r\n  <\/tr>\r\n<\/thead>\r\n<tbody>\r\n  <tr>\r\n    <td class=\"tg-9fd4\">1<\/td>\r\n    <td class=\"tg-0lax\">Marie <\/td>\r\n    <td class=\"tg-0lax\">Nevier<\/td>\r\n    <td class=\"tg-0lax\">mnevier@exemple.com<\/td>\r\n    <td class=\"tg-0lax\">7<\/td>\r\n    <td class=\"tg-0lax\">Paris<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-9fd4\">2<\/td>\r\n    <td class=\"tg-0lax\">Ga\u00ebtan<\/td>\r\n    <td class=\"tg-0lax\">Doucle<\/td>\r\n    <td class=\"tg-0lax\">gdoucle@exemple.com<\/td>\r\n    <td class=\"tg-0lax\">4<\/td>\r\n    <td class=\"tg-0lax\">Nantes<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-9fd4\">3<\/td>\r\n    <td class=\"tg-0lax\">Louis<\/td>\r\n    <td class=\"tg-0lax\">Chenard<\/td>\r\n    <td class=\"tg-0lax\">lchenard@exemple.com<\/td>\r\n    <td class=\"tg-0lax\">1<\/td>\r\n    <td class=\"tg-0lax\">Lyon<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-9fd4\">4<\/td>\r\n    <td class=\"tg-0lax\">Olivia<\/td>\r\n    <td class=\"tg-0lax\">Caffin<\/td>\r\n    <td class=\"tg-0lax\">ocaffin@exemple.com<\/td>\r\n    <td class=\"tg-0lax\">9<\/td>\r\n    <td class=\"tg-0lax\">Bordeaux<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-9fd4\">5<\/td>\r\n    <td class=\"tg-0lax\">Camille<\/td>\r\n    <td class=\"tg-0lax\">Loutran<\/td>\r\n    <td class=\"tg-0lax\">cloutran@exemple.com<\/td>\r\n    <td class=\"tg-0lax\">3<\/td>\r\n    <td class=\"tg-0lax\">Paris<\/td>\r\n  <\/tr>\r\n<\/tbody>\r\n<\/table>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-83b8437 elementor-widget elementor-widget-heading\" data-id=\"83b8437\" 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\">Exemple de s\u00e9lection par ville<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-804e721 elementor-widget elementor-widget-text-editor\" data-id=\"804e721\" 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><span style=\"font-weight: 400;\">En reprenant la syntaxe de la commande WHERE et en ajoutant les bons \u00e9l\u00e9ments, vous pouvez filtrer cette table comme bon vous semble. Par exemple, pour <\/span><b>s\u00e9lectionner uniquement les clients de la ville de Paris<\/b><span style=\"font-weight: 400;\">, nous effectuons donc la requ\u00eate :\u00a0<\/span><\/p><pre style=\"padding-left: 40px;\"><span style=\"font-weight: 400;\">SELECT * FROM clients WHERE ville = \u2018Paris\u2019<\/span><\/pre><p><span style=\"font-weight: 400;\">Cette requ\u00eate retourne alors la s\u00e9lection suivante :\u00a0<\/span><\/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-12d60ce elementor-widget__width-initial elementor-widget elementor-widget-html\" data-id=\"12d60ce\" 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\">\r\n.tg  {border-collapse:collapse;border-spacing:0;}\r\n.tg td{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\r\n  overflow:hidden;padding:10px 5px;word-break:normal;}\r\n.tg th{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\r\n  font-weight:normal;overflow:hidden;padding:10px 5px;word-break:normal;}\r\n.tg .tg-pu0z{background-color:#9b9b9b;border-color:inherit;font-weight:bold;text-align:left;vertical-align:top}\r\n.tg .tg-0pky{border-color:inherit;text-align:left;vertical-align:top}\r\n<\/style>\r\n<table class=\"tg\">\r\n<thead>\r\n  <tr>\r\n    <th class=\"tg-pu0z\">id<\/th>\r\n    <th class=\"tg-pu0z\">Pr\u00e9nom<\/th>\r\n    <th class=\"tg-pu0z\">Nom<\/th>\r\n    <th class=\"tg-pu0z\">e-mail<\/th>\r\n    <th class=\"tg-pu0z\">nbr_commandes<\/th>\r\n    <th class=\"tg-pu0z\">Ville<\/th>\r\n  <\/tr>\r\n<\/thead>\r\n<tbody>\r\n  <tr>\r\n    <td class=\"tg-pu0z\">1<\/td>\r\n    <td class=\"tg-0pky\">Marie<\/td>\r\n    <td class=\"tg-0pky\">Nevier<\/td>\r\n    <td class=\"tg-0pky\">mnevier@exemple.com<\/td>\r\n    <td class=\"tg-0pky\">7<\/td>\r\n    <td class=\"tg-0pky\">Paris<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-pu0z\">2<\/td>\r\n    <td class=\"tg-0pky\">Camille<\/td>\r\n    <td class=\"tg-0pky\">Loutran<\/td>\r\n    <td class=\"tg-0pky\">cloutran@exemple.com<\/td>\r\n    <td class=\"tg-0pky\">3<\/td>\r\n    <td class=\"tg-0pky\">Paris<\/td>\r\n  <\/tr>\r\n<\/tbody>\r\n<\/table>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3d14a71 elementor-widget elementor-widget-text-editor\" data-id=\"3d14a71\" 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><span style=\"font-weight: 400;\">Notez que les valeurs pr\u00e9cis\u00e9es dans les conditions sont sensibles \u00e0 la casse. Cela signifie que vous devez bien respecter les majuscules et minuscules pour filtrer correctement. Dans l\u2019exemple ci-dessus, il est n\u00e9cessaire d\u2019utiliser la valeur \u2018Paris\u2019 et non \u2018paris\u2019.<\/span><\/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-7d0f209 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"7d0f209\" 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\/formation-sql\">\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\">Apprendre comment utiliser 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-10a4266 elementor-widget elementor-widget-heading\" data-id=\"10a4266\" 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\">Exemple de s\u00e9lection par nombre de commandes<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7e140ce elementor-widget elementor-widget-text-editor\" data-id=\"7e140ce\" 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><span style=\"font-weight: 400;\">Pour un commerce physique ou en ligne, il peut \u00eatre int\u00e9ressant de <\/span><b>filtrer les clients par nombre de commandes<\/b><span style=\"font-weight: 400;\">. Si nous reprenons le tableau initial, effectuons la requ\u00eate suivante :\u00a0<\/span><\/p><pre style=\"padding-left: 40px;\"><span style=\"font-weight: 400;\">SELECT * FROM clients WHERE nbr_commandes &gt;= 4<\/span><\/pre><p><span style=\"font-weight: 400;\">Cette requ\u00eate retourne alors tous les clients ayant effectu\u00e9 4 commandes ou plus :\u00a0<\/span><\/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-d6419b0 elementor-widget__width-initial elementor-widget elementor-widget-html\" data-id=\"d6419b0\" 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\">\r\n.tg  {border-collapse:collapse;border-spacing:0;}\r\n.tg td{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\r\n  overflow:hidden;padding:10px 5px;word-break:normal;}\r\n.tg th{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\r\n  font-weight:normal;overflow:hidden;padding:10px 5px;word-break:normal;}\r\n.tg .tg-9fd4{background-color:#9b9b9b;font-weight:bold;text-align:left;vertical-align:top}\r\n.tg .tg-0lax{text-align:left;vertical-align:top}\r\n<\/style>\r\n<table class=\"tg\">\r\n<thead>\r\n  <tr>\r\n    <th class=\"tg-9fd4\">id<\/th>\r\n    <th class=\"tg-9fd4\">Pr\u00e9nom<\/th>\r\n    <th class=\"tg-9fd4\">Nom<\/th>\r\n    <th class=\"tg-9fd4\">e-mail<\/th>\r\n    <th class=\"tg-9fd4\">nbr_commandes<\/th>\r\n    <th class=\"tg-9fd4\">Ville<\/th>\r\n  <\/tr>\r\n<\/thead>\r\n<tbody>\r\n  <tr>\r\n    <td class=\"tg-9fd4\">1<\/td>\r\n    <td class=\"tg-0lax\">Marie<\/td>\r\n    <td class=\"tg-0lax\">Nevier<\/td>\r\n    <td class=\"tg-0lax\">mnevier@exemple.com<\/td>\r\n    <td class=\"tg-0lax\">7<\/td>\r\n    <td class=\"tg-0lax\">Paris<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-9fd4\">2<\/td>\r\n    <td class=\"tg-0lax\">Ga\u00ebtan<\/td>\r\n    <td class=\"tg-0lax\">Doucle<\/td>\r\n    <td class=\"tg-0lax\">gdoucle@exemple.com<\/td>\r\n    <td class=\"tg-0lax\">4<\/td>\r\n    <td class=\"tg-0lax\">Nantes<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-9fd4\">3<\/td>\r\n    <td class=\"tg-0lax\">Olivia<\/td>\r\n    <td class=\"tg-0lax\">Caffin<\/td>\r\n    <td class=\"tg-0lax\">ocaffin@exemple.com<\/td>\r\n    <td class=\"tg-0lax\">9<\/td>\r\n    <td class=\"tg-0lax\">Bordeaux<\/td>\r\n  <\/tr>\r\n<\/tbody>\r\n<\/table>\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-a189b70 e-flex e-con-boxed e-con\" data-id=\"a189b70\" 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-30cb421 elementor-widget elementor-widget-heading\" data-id=\"30cb421\" 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\">Les op\u00e9rateurs de comparaisons de la commande WHERE<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6348f42 elementor-widget elementor-widget-text-editor\" data-id=\"6348f42\" 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><span style=\"font-weight: 400;\">Dans nos deux exemples, nous avons utilis\u00e9 les op\u00e9rateurs = et &gt;= pour filtrer les r\u00e9sultats dans la requ\u00eate SQL. Mais ce ne sont pas les seuls op\u00e9rateurs applicables avec la commande WHERE. Retrouvez <\/span><b>la liste des op\u00e9rateurs<\/b><span style=\"font-weight: 400;\"> les plus couramment utilis\u00e9s dans le tableau ci-dessous : <\/span><\/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-1dc9827 elementor-widget__width-initial elementor-widget elementor-widget-html\" data-id=\"1dc9827\" 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\">\r\n.tg  {border-collapse:collapse;border-spacing:0;}\r\n.tg td{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\r\n  overflow:hidden;padding:10px 5px;word-break:normal;}\r\n.tg th{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\r\n  font-weight:normal;overflow:hidden;padding:10px 5px;word-break:normal;}\r\n.tg .tg-52qd{background-color:#6665cd;font-size:18px;font-weight:bold;text-align:left;vertical-align:top}\r\n.tg .tg-0lax{text-align:left;vertical-align:top}\r\n<\/style>\r\n<table class=\"tg\">\r\n<thead>\r\n  <tr>\r\n    <th class=\"tg-52qd\">Op\u00e9rateur<\/th>\r\n    <th class=\"tg-52qd\">Description de l'op\u00e9rateur<\/th>\r\n  <\/tr>\r\n<\/thead>\r\n<tbody>\r\n  <tr>\r\n    <td class=\"tg-0lax\"><span style=\"font-weight:400;font-style:normal;text-decoration:none;color:#000;background-color:transparent\">=<\/span><\/td>\r\n    <td class=\"tg-0lax\"><span style=\"font-weight:400;font-style:normal;text-decoration:none;color:#000;background-color:transparent\">\u00c9gal<\/span><\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-0lax\"><span style=\"font-weight:400;font-style:normal;text-decoration:none;color:#000;background-color:transparent\">&lt;&gt; ou !=<\/span><\/td>\r\n    <td class=\"tg-0lax\"><span style=\"font-weight:400;font-style:normal;text-decoration:none;color:#000;background-color:transparent\">Diff\u00e9rent (pas \u00e9gal)<\/span><\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-0lax\"><span style=\"font-weight:400;font-style:normal;text-decoration:none;color:#000;background-color:transparent\">&lt;<\/span><\/td>\r\n    <td class=\"tg-0lax\"><span style=\"font-weight:400;font-style:normal;text-decoration:none;color:#000;background-color:transparent\">Strictement inf\u00e9rieur<\/span><\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-0lax\"><span style=\"font-weight:400;font-style:normal;text-decoration:none;color:#000;background-color:transparent\">&gt;<\/span><\/td>\r\n    <td class=\"tg-0lax\"><span style=\"font-weight:400;font-style:normal;text-decoration:none;color:#000;background-color:transparent\">Strictement sup\u00e9rieur<\/span><\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-0lax\"><span style=\"font-weight:400;font-style:normal;text-decoration:none;color:#000;background-color:transparent\">&lt;=<\/span><\/td>\r\n    <td class=\"tg-0lax\"><span style=\"font-weight:400;font-style:normal;text-decoration:none;color:#000;background-color:transparent\">Inf\u00e9rieur ou \u00e9gal<\/span><\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-0lax\"><span style=\"font-weight:400;font-style:normal;text-decoration:none;color:#000;background-color:transparent\">&gt;=<\/span><\/td>\r\n    <td class=\"tg-0lax\"><span style=\"font-weight:400;font-style:normal;text-decoration:none;color:#000;background-color:transparent\">Sup\u00e9rieur ou \u00e9gal<\/span><\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-0lax\"><span style=\"font-weight:400;font-style:normal;text-decoration:none;color:#000;background-color:transparent\">IN<\/span><\/td>\r\n    <td class=\"tg-0lax\"><span style=\"font-weight:400;font-style:normal;text-decoration:none;color:#000;background-color:transparent\">Liste de valeurs possibles<\/span><\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-0lax\"><span style=\"font-weight:400;font-style:normal;text-decoration:none;color:#000;background-color:transparent\">BETWEEN<\/span><\/td>\r\n    <td class=\"tg-0lax\"><span style=\"font-weight:400;font-style:normal;text-decoration:none;color:#000;background-color:transparent\">Valeurs comprises entre un intervalle de donn\u00e9es (plage de valeurs ou de dates)<\/span><\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-0lax\"><span style=\"font-weight:400;font-style:normal;text-decoration:none;color:#000;background-color:transparent\">LIKE<\/span><\/td>\r\n    <td class=\"tg-0lax\"><span style=\"font-weight:400;font-style:normal;text-decoration:none;color:#000;background-color:transparent\">Comprend le d\u00e9but, milieu ou fin d\u2019un mot<\/span><\/td>\r\n  <\/tr>\r\n  <tr>\r\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>\r\n    <td class=\"tg-0lax\"><span style=\"font-weight:400;font-style:normal;text-decoration:none;color:#000;background-color:transparent\">Valeur est nulle<\/span><\/td>\r\n  <\/tr>\r\n  <tr>\r\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>\r\n    <td class=\"tg-0lax\"><span style=\"font-weight:400;font-style:normal;text-decoration:none;color:#000;background-color:transparent\">Valeur n\u2019est pas nulle<\/span><\/td>\r\n  <\/tr>\r\n<\/tbody>\r\n<\/table>\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-ee8128e e-flex e-con-boxed e-con\" data-id=\"ee8128e\" 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-72c3adb elementor-widget elementor-widget-heading\" data-id=\"72c3adb\" 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 sur SQL WHERE<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b5a5dcc elementor-widget elementor-widget-text-editor\" data-id=\"b5a5dcc\" 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><span style=\"font-weight: 400;\">En bref, WHERE est une commande SQL particuli\u00e8rement utile pour s\u00e9lectionner les lignes d\u2019une table qui respectent une condition pr\u00e9cise. Les diff\u00e9rents op\u00e9rateurs permettent d\u2019utiliser la commande WHERE pour <strong>filtrer diff\u00e9rentes valeurs<\/strong>, comme des chiffres, des dates ou des mots.\u00a0<\/span><\/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-ad2069a elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"ad2069a\" 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\/formation-sql\">\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\">Ma\u00eetriser SQL avec 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-2aec7ab e-flex e-con-boxed e-con\" data-id=\"2aec7ab\" 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-7d7f2b0 elementor-widget elementor-widget-html\" data-id=\"7d7f2b0\" 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\">\r\n{\r\n  \"@context\": \"https:\/\/schema.org\",\r\n  \"@type\": \"FAQPage\",\r\n  \"mainEntity\": [{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"La syntaxe de la commande WHERE en SQL\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"La commande WHERE se compose d\u2019une commande SELECT et de la condition WHERE. La syntaxe la plus courante est la suivante :SELECT nom_colonne1, nom_colonne2 FROM nom_table WHERE une_condition\"\r\n    }\r\n  },{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"Les op\u00e9rateurs de comparaisons de la commande WHERE\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"Dans nos deux exemples, nous avons utilis\u00e9 les op\u00e9rateurs = et >= pour filtrer les r\u00e9sultats dans la requ\u00eate SQL. Mais ce ne sont pas les seuls op\u00e9rateurs applicables avec la commande WHERE.\"\r\n    }\r\n  }]\r\n}\r\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>La commande WHERE en SQL est utilis\u00e9e dans les requ\u00eates afin de filtrer les donn\u00e9es qui respectent une condition pr\u00e9cise. Cela permet d\u2019extraire uniquement les lignes d\u00e9sir\u00e9es d\u2019une table dans une base de donn\u00e9es. Avec cette commande, il est possible de s\u00e9lectionner un sous-ensemble de donn\u00e9es en fonction de crit\u00e8res pr\u00e9cis. D\u00e9couvrez en d\u00e9tail la [&hellip;]<\/p>\n","protected":false},"author":78,"featured_media":189767,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"content-type":"","inline_featured_image":false},"categories":[2497],"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>Commande WHERE sur SQL : guide complet | DataScientest.com<\/title>\n<meta name=\"description\" content=\"D\u00e9couvrez en d\u00e9tail la syntaxe de la commande WHERE en SQL, ses cas d\u2019utilisation et ses op\u00e9rateurs de comparaisons pour effectuer vos requ\u00eates avec plus d\u2019efficacit\u00e9.\" \/>\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\/sql-where-tout-savoir\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Commande WHERE sur SQL : guide complet\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/sql-where-tout-savoir\" \/>\n<meta property=\"og:site_name\" content=\"Formation Data Science | DataScientest.com\" \/>\n<meta property=\"article:published_time\" content=\"2023-02-13T15:38:26+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-09T13:54:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/02\/sql-where.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"600\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"J\u00e9r\u00e9my Robert\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"J\u00e9r\u00e9my Robert\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\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\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/sql-where-tout-savoir\",\"url\":\"https:\/\/datascientest.com\/sql-where-tout-savoir\",\"name\":\"Commande WHERE sur SQL : guide complet | DataScientest.com\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/#website\"},\"datePublished\":\"2023-02-13T15:38:26+00:00\",\"dateModified\":\"2023-11-09T13:54:06+00:00\",\"author\":{\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/7af2361c48e24e79a8aa2360e6e74925\"},\"description\":\"D\u00e9couvrez en d\u00e9tail la syntaxe de la commande WHERE en SQL, ses cas d\u2019utilisation et ses op\u00e9rateurs de comparaisons pour effectuer vos requ\u00eates avec plus d\u2019efficacit\u00e9.\",\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/sql-where-tout-savoir\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/datascientest.com\/#website\",\"url\":\"https:\/\/datascientest.com\/\",\"name\":\"Formation Data Science | DataScientest.com\",\"description\":\"Leader de la formation en Data Science\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/datascientest.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/7af2361c48e24e79a8aa2360e6e74925\",\"name\":\"J\u00e9r\u00e9my Robert\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/jeremyrobert.jpeg\",\"contentUrl\":\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/jeremyrobert.jpeg\",\"caption\":\"J\u00e9r\u00e9my Robert\"},\"description\":\"J\u00e9r\u00e9my Robert est actuellement Directeur p\u00e9dagogique B2B chez DataScientest.com. Avant de rejoindre DataScientest, il a travaill\u00e9 en tant que Consultant Business Intelligence chez DEAPDATA, o\u00f9 il a g\u00e9r\u00e9 des projets dans les domaines de l'assurance, bancaire et industrie. Il a \u00e9galement \u00e9t\u00e9 Co-fondateur et pr\u00e9sident de Tripzer. En tant que consultant ind\u00e9pendant, J\u00e9r\u00e9my a propos\u00e9 des formations sur MicroStrategy pour divers niveaux professionnels. Il est dipl\u00f4m\u00e9 de l'Universit\u00e9 Paris Cit\u00e9 avec un Master MIAGE, combinant comp\u00e9tences en informatique et gestion.\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/jeremyrobert1\/\",\"Data Science\"],\"url\":\"https:\/\/datascientest.com\/author\/jeremyrobert\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Commande WHERE sur SQL : guide complet | DataScientest.com","description":"D\u00e9couvrez en d\u00e9tail la syntaxe de la commande WHERE en SQL, ses cas d\u2019utilisation et ses op\u00e9rateurs de comparaisons pour effectuer vos requ\u00eates avec plus d\u2019efficacit\u00e9.","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\/sql-where-tout-savoir","og_locale":"fr_FR","og_type":"article","og_title":"Commande WHERE sur SQL : guide complet","og_url":"https:\/\/datascientest.com\/sql-where-tout-savoir","og_site_name":"Formation Data Science | DataScientest.com","article_published_time":"2023-02-13T15:38:26+00:00","article_modified_time":"2023-11-09T13:54:06+00:00","og_image":[{"width":1200,"height":600,"url":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/02\/sql-where.png","type":"image\/png"}],"author":"J\u00e9r\u00e9my Robert","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"J\u00e9r\u00e9my Robert","Dur\u00e9e de lecture estim\u00e9e":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/datascientest.com\/sql-where-tout-savoir","url":"https:\/\/datascientest.com\/sql-where-tout-savoir","name":"Commande WHERE sur SQL : guide complet | DataScientest.com","isPartOf":{"@id":"https:\/\/datascientest.com\/#website"},"datePublished":"2023-02-13T15:38:26+00:00","dateModified":"2023-11-09T13:54:06+00:00","author":{"@id":"https:\/\/datascientest.com\/#\/schema\/person\/7af2361c48e24e79a8aa2360e6e74925"},"description":"D\u00e9couvrez en d\u00e9tail la syntaxe de la commande WHERE en SQL, ses cas d\u2019utilisation et ses op\u00e9rateurs de comparaisons pour effectuer vos requ\u00eates avec plus d\u2019efficacit\u00e9.","inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/sql-where-tout-savoir"]}]},{"@type":"WebSite","@id":"https:\/\/datascientest.com\/#website","url":"https:\/\/datascientest.com\/","name":"Formation Data Science | DataScientest.com","description":"Leader de la formation en Data Science","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/datascientest.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"fr-FR"},{"@type":"Person","@id":"https:\/\/datascientest.com\/#\/schema\/person\/7af2361c48e24e79a8aa2360e6e74925","name":"J\u00e9r\u00e9my Robert","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/datascientest.com\/#\/schema\/person\/image\/","url":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/jeremyrobert.jpeg","contentUrl":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/jeremyrobert.jpeg","caption":"J\u00e9r\u00e9my Robert"},"description":"J\u00e9r\u00e9my Robert est actuellement Directeur p\u00e9dagogique B2B chez DataScientest.com. Avant de rejoindre DataScientest, il a travaill\u00e9 en tant que Consultant Business Intelligence chez DEAPDATA, o\u00f9 il a g\u00e9r\u00e9 des projets dans les domaines de l'assurance, bancaire et industrie. Il a \u00e9galement \u00e9t\u00e9 Co-fondateur et pr\u00e9sident de Tripzer. En tant que consultant ind\u00e9pendant, J\u00e9r\u00e9my a propos\u00e9 des formations sur MicroStrategy pour divers niveaux professionnels. Il est dipl\u00f4m\u00e9 de l'Universit\u00e9 Paris Cit\u00e9 avec un Master MIAGE, combinant comp\u00e9tences en informatique et gestion.","sameAs":["https:\/\/www.linkedin.com\/in\/jeremyrobert1\/","Data Science"],"url":"https:\/\/datascientest.com\/author\/jeremyrobert"}]}},"_links":{"self":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/189765"}],"collection":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/users\/78"}],"replies":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/comments?post=189765"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/189765\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media\/189767"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media?parent=189765"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/categories?post=189765"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/tags?post=189765"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}