{"id":3152,"date":"2022-01-21T16:03:49","date_gmt":"2022-01-21T15:03:49","guid":{"rendered":"http:\/\/slamsoft-corp.com\/?p=3152"},"modified":"2022-01-21T16:04:44","modified_gmt":"2022-01-21T15:04:44","slug":"les-operateurs-en-sql","status":"publish","type":"post","link":"https:\/\/slamsoft-corp.com\/index.php\/2022\/01\/21\/les-operateurs-en-sql\/","title":{"rendered":"Les op\u00e9rateurs en SQL"},"content":{"rendered":"\n
\"\"<\/figure>\n\n\n\n

Les op\u00e9rateurs de comparaison:<\/span><\/h3>\n\n\n\n

Les op\u00e9rateurs de comparaison testent si 2 expressions sont identiques afin de v\u00e9rifier les conditions.<\/p>\n\n\n\n

X =Y<\/td> X \u00e9gal \u00e0 Y <\/td><\/tr>
X != Y<\/td>X diff\u00e9rent de Y (hors norme ISO)<\/td><\/tr>
X < > Y<\/td> X diff\u00e9rent de Y <\/td><\/tr>
X > Y et X < Y <\/td> X sup\u00e9rieur \u00e0 Y \/ X inf\u00e9rieur \u00e0 Y <\/td><\/tr>
X >= Y et X <= Y <\/td> X sup\u00e9rieur ou \u00e9gal \u00e0 Y \/ X inf\u00e9rieur ou \u00e9gal \u00e0 Y <\/td><\/tr>
X !< Y et X !> Y<\/td>X non inf\u00e9rieur \u00e0 Y \/ X non sup\u00e9rieur \u00e0 Y (hors norme ISO) <\/td><\/tr>
X BETWEEN Y AND Z <\/td> X est compris entre Y et Z <\/td><\/tr>
X IN (Y1, Y2, Y3, …)<\/td> X est pr\u00e9sent dans la liste (Y1, Y2, …) <\/td><\/tr>
X IS NULL<\/td> X n’a pas de valeur <\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Exemple:<\/em><\/p>\n\n\n\n

SELECT * FROM table AS t\nWHERE x IS NULL<\/strong>;<\/code><\/pre>\n\n\n\n


Les op\u00e9rateur logiques<\/span><\/h3>\n\n\n\n
Les op\u00e9rateurs logiques permettent de complexifier nos conditions.<\/p>\n\n\n\n
  • OR (ou)<\/li>
  • AND (et)<\/li>
  • NOT (non)<\/li><\/ul>\n\n\n\n
    Exemple:<\/em><\/p>\n\n\n\n
    SELECT * FROM table AS t\nWHERE (x IS NULL) AND<\/strong> (y IS NOT<\/strong> NULL);<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"
    Les op\u00e9rateurs de comparaison: Les op\u00e9rateurs de comparaison testent si 2 expressions […]<\/p>\n","protected":false},"author":1,"featured_media":3157,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false},"categories":[23,13],"tags":[],"yoast_head":"\nLes op\u00e9rateurs en SQL - slamsOft Corp.<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/slamsoft-corp.com\/index.php\/2022\/01\/21\/les-operateurs-en-sql\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Les op\u00e9rateurs en SQL - slamsOft Corp.\" \/>\n<meta property=\"og:description\" content=\"Les op\u00e9rateurs de comparaison: Les op\u00e9rateurs de comparaison testent si 2 expressions […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/slamsoft-corp.com\/index.php\/2022\/01\/21\/les-operateurs-en-sql\/\" \/>\n<meta property=\"og:site_name\" content=\"slamsOft Corp.\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/EggManu\/\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/EggManu\/\" \/>\n<meta property=\"article:published_time\" content=\"2022-01-21T15:03:49+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-01-21T15:04:44+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/slamsoft-corp.com\/wp-content\/uploads\/2022\/01\/egg-operateurSQL-bandeau.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"594\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"SlamsOft\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@EggMarty\" \/>\n<meta name=\"twitter:site\" content=\"@EggMarty\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"SlamsOft\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/slamsoft-corp.com\/#website\",\"url\":\"https:\/\/slamsoft-corp.com\/\",\"name\":\"slamsOft Corp.\",\"description\":\"Tube craft\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/slamsoft-corp.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/slamsoft-corp.com\/index.php\/2022\/01\/21\/les-operateurs-en-sql\/#primaryimage\",\"url\":\"https:\/\/slamsoft-corp.com\/wp-content\/uploads\/2022\/01\/egg-operateurSQL-bandeau.jpg\",\"contentUrl\":\"https:\/\/slamsoft-corp.com\/wp-content\/uploads\/2022\/01\/egg-operateurSQL-bandeau.jpg\",\"width\":1920,\"height\":594},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/slamsoft-corp.com\/index.php\/2022\/01\/21\/les-operateurs-en-sql\/\",\"url\":\"https:\/\/slamsoft-corp.com\/index.php\/2022\/01\/21\/les-operateurs-en-sql\/\",\"name\":\"Les op\u00e9rateurs en SQL - slamsOft Corp.\",\"isPartOf\":{\"@id\":\"https:\/\/slamsoft-corp.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/slamsoft-corp.com\/index.php\/2022\/01\/21\/les-operateurs-en-sql\/#primaryimage\"},\"datePublished\":\"2022-01-21T15:03:49+00:00\",\"dateModified\":\"2022-01-21T15:04:44+00:00\",\"author\":{\"@id\":\"https:\/\/slamsoft-corp.com\/#\/schema\/person\/230a6256c44062d2950c818ef8743acf\"},\"breadcrumb\":{\"@id\":\"https:\/\/slamsoft-corp.com\/index.php\/2022\/01\/21\/les-operateurs-en-sql\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/slamsoft-corp.com\/index.php\/2022\/01\/21\/les-operateurs-en-sql\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/slamsoft-corp.com\/index.php\/2022\/01\/21\/les-operateurs-en-sql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/slamsoft-corp.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Les op\u00e9rateurs en SQL\"}]},{\"@type\":\"Person\",\"@id\":\"https:\/\/slamsoft-corp.com\/#\/schema\/person\/230a6256c44062d2950c818ef8743acf\",\"name\":\"SlamsOft\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/slamsoft-corp.com\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/slamsoft-corp.com\/wp-content\/uploads\/2018\/04\/avatar_user_1_1523361156-96x96.jpg\",\"contentUrl\":\"http:\/\/slamsoft-corp.com\/wp-content\/uploads\/2018\/04\/avatar_user_1_1523361156-96x96.jpg\",\"caption\":\"SlamsOft\"},\"sameAs\":[\"http:\/\/slamsoft-corp.com\/\",\"https:\/\/www.facebook.com\/EggManu\/\",\"https:\/\/twitter.com\/EggMarty\"],\"url\":\"https:\/\/slamsoft-corp.com\/index.php\/author\/admin4504\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Les op\u00e9rateurs en SQL - slamsOft Corp.","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:\/\/slamsoft-corp.com\/index.php\/2022\/01\/21\/les-operateurs-en-sql\/","og_locale":"fr_FR","og_type":"article","og_title":"Les op\u00e9rateurs en SQL - slamsOft Corp.","og_description":"Les op\u00e9rateurs de comparaison: Les op\u00e9rateurs de comparaison testent si 2 expressions […]","og_url":"https:\/\/slamsoft-corp.com\/index.php\/2022\/01\/21\/les-operateurs-en-sql\/","og_site_name":"slamsOft Corp.","article_publisher":"https:\/\/www.facebook.com\/EggManu\/","article_author":"https:\/\/www.facebook.com\/EggManu\/","article_published_time":"2022-01-21T15:03:49+00:00","article_modified_time":"2022-01-21T15:04:44+00:00","og_image":[{"width":1920,"height":594,"url":"https:\/\/slamsoft-corp.com\/wp-content\/uploads\/2022\/01\/egg-operateurSQL-bandeau.jpg","type":"image\/jpeg"}],"author":"SlamsOft","twitter_card":"summary_large_image","twitter_creator":"@EggMarty","twitter_site":"@EggMarty","twitter_misc":{"\u00c9crit par":"SlamsOft","Dur\u00e9e de lecture estim\u00e9e":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebSite","@id":"https:\/\/slamsoft-corp.com\/#website","url":"https:\/\/slamsoft-corp.com\/","name":"slamsOft Corp.","description":"Tube craft","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/slamsoft-corp.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"fr-FR"},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/slamsoft-corp.com\/index.php\/2022\/01\/21\/les-operateurs-en-sql\/#primaryimage","url":"https:\/\/slamsoft-corp.com\/wp-content\/uploads\/2022\/01\/egg-operateurSQL-bandeau.jpg","contentUrl":"https:\/\/slamsoft-corp.com\/wp-content\/uploads\/2022\/01\/egg-operateurSQL-bandeau.jpg","width":1920,"height":594},{"@type":"WebPage","@id":"https:\/\/slamsoft-corp.com\/index.php\/2022\/01\/21\/les-operateurs-en-sql\/","url":"https:\/\/slamsoft-corp.com\/index.php\/2022\/01\/21\/les-operateurs-en-sql\/","name":"Les op\u00e9rateurs en SQL - slamsOft Corp.","isPartOf":{"@id":"https:\/\/slamsoft-corp.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/slamsoft-corp.com\/index.php\/2022\/01\/21\/les-operateurs-en-sql\/#primaryimage"},"datePublished":"2022-01-21T15:03:49+00:00","dateModified":"2022-01-21T15:04:44+00:00","author":{"@id":"https:\/\/slamsoft-corp.com\/#\/schema\/person\/230a6256c44062d2950c818ef8743acf"},"breadcrumb":{"@id":"https:\/\/slamsoft-corp.com\/index.php\/2022\/01\/21\/les-operateurs-en-sql\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/slamsoft-corp.com\/index.php\/2022\/01\/21\/les-operateurs-en-sql\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/slamsoft-corp.com\/index.php\/2022\/01\/21\/les-operateurs-en-sql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/slamsoft-corp.com\/"},{"@type":"ListItem","position":2,"name":"Les op\u00e9rateurs en SQL"}]},{"@type":"Person","@id":"https:\/\/slamsoft-corp.com\/#\/schema\/person\/230a6256c44062d2950c818ef8743acf","name":"SlamsOft","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/slamsoft-corp.com\/#\/schema\/person\/image\/","url":"http:\/\/slamsoft-corp.com\/wp-content\/uploads\/2018\/04\/avatar_user_1_1523361156-96x96.jpg","contentUrl":"http:\/\/slamsoft-corp.com\/wp-content\/uploads\/2018\/04\/avatar_user_1_1523361156-96x96.jpg","caption":"SlamsOft"},"sameAs":["http:\/\/slamsoft-corp.com\/","https:\/\/www.facebook.com\/EggManu\/","https:\/\/twitter.com\/EggMarty"],"url":"https:\/\/slamsoft-corp.com\/index.php\/author\/admin4504\/"}]}},"_links":{"self":[{"href":"https:\/\/slamsoft-corp.com\/index.php\/wp-json\/wp\/v2\/posts\/3152"}],"collection":[{"href":"https:\/\/slamsoft-corp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/slamsoft-corp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/slamsoft-corp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/slamsoft-corp.com\/index.php\/wp-json\/wp\/v2\/comments?post=3152"}],"version-history":[{"count":14,"href":"https:\/\/slamsoft-corp.com\/index.php\/wp-json\/wp\/v2\/posts\/3152\/revisions"}],"predecessor-version":[{"id":3167,"href":"https:\/\/slamsoft-corp.com\/index.php\/wp-json\/wp\/v2\/posts\/3152\/revisions\/3167"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/slamsoft-corp.com\/index.php\/wp-json\/wp\/v2\/media\/3157"}],"wp:attachment":[{"href":"https:\/\/slamsoft-corp.com\/index.php\/wp-json\/wp\/v2\/media?parent=3152"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/slamsoft-corp.com\/index.php\/wp-json\/wp\/v2\/categories?post=3152"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/slamsoft-corp.com\/index.php\/wp-json\/wp\/v2\/tags?post=3152"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}