{"id":19232,"date":"2024-03-15T18:30:23","date_gmt":"2024-03-15T18:30:23","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-to-use-multiple-condition-checking-in-sql-using-case-when-then-else-end\/"},"modified":"2024-03-21T15:12:35","modified_gmt":"2024-03-21T15:12:35","slug":"how-to-use-multiple-condition-checking-in-sql-using-case-when-then-else-end","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-to-use-multiple-condition-checking-in-sql-using-case-when-then-else-end\/","title":{"rendered":"How to use multiple condition checking in SQL using Case When Then Else End?"},"content":{"rendered":"<p>In SQL, you can use the CASE WHEN THEN ELSE END structure to make multiple condition judgments. The syntax is as follows:<\/p>\n<pre class=\"post-pre\"><code>CASE\r\n    WHEN condition1 THEN result1\r\n    WHEN condition2 THEN result2\r\n    ...\r\n    ELSE result\r\nEND\r\n<\/code><\/pre>\n<p>The conditions such as condition1 and condition2 are expression conditions, while the results such as result1 and result2 are the corresponding return values for each condition. If condition1 is met, return result1; if condition2 is met, return result2; and so on. If none of the conditions are met, return the result.<\/p>\n<p>Here is an example:<\/p>\n<pre class=\"post-pre\"><code><span class=\"hljs-keyword\">SELECT<\/span> column1,\r\n       column2,\r\n       <span class=\"hljs-keyword\">CASE<\/span>\r\n           <span class=\"hljs-keyword\">WHEN<\/span> column3 <span class=\"hljs-operator\">=<\/span> <span class=\"hljs-string\">'A'<\/span> <span class=\"hljs-keyword\">THEN<\/span> <span class=\"hljs-string\">'Option A'<\/span>\r\n           <span class=\"hljs-keyword\">WHEN<\/span> column3 <span class=\"hljs-operator\">=<\/span> <span class=\"hljs-string\">'B'<\/span> <span class=\"hljs-keyword\">THEN<\/span> <span class=\"hljs-string\">'Option B'<\/span>\r\n           <span class=\"hljs-keyword\">ELSE<\/span> <span class=\"hljs-string\">'Other'<\/span>\r\n       <span class=\"hljs-keyword\">END<\/span> <span class=\"hljs-keyword\">AS<\/span> option\r\n<span class=\"hljs-keyword\">FROM<\/span> your_table;\r\n<\/code><\/pre>\n<p>In the given example, a condition is evaluated based on the value of column3, and the corresponding option is returned to the option column. If the value of column3 is &#8216;A&#8217;, &#8216;Option A&#8217; is returned. If the value of column3 is &#8216;B&#8217;, &#8216;Option B&#8217; is returned. If the value of column3 does not satisfy any condition, &#8216;Other&#8217; is returned.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In SQL, you can use the CASE WHEN THEN ELSE END structure to make multiple condition judgments. The syntax is as follows: CASE WHEN condition1 THEN result1 WHEN condition2 THEN result2 &#8230; ELSE result END The conditions such as condition1 and condition2 are expression conditions, while the results such as result1 and result2 are the [&hellip;]<\/p>\n","protected":false},"author":12,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-19232","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to use multiple condition checking in SQL using Case When Then Else End? - Blog - Silicon Cloud<\/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:\/\/www.silicloud.com\/blog\/how-to-use-multiple-condition-checking-in-sql-using-case-when-then-else-end\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to use multiple condition checking in SQL using Case When Then Else End?\" \/>\n<meta property=\"og:description\" content=\"In SQL, you can use the CASE WHEN THEN ELSE END structure to make multiple condition judgments. The syntax is as follows: CASE WHEN condition1 THEN result1 WHEN condition2 THEN result2 ... ELSE result END The conditions such as condition1 and condition2 are expression conditions, while the results such as result1 and result2 are the [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-to-use-multiple-condition-checking-in-sql-using-case-when-then-else-end\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-15T18:30:23+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-21T15:12:35+00:00\" \/>\n<meta name=\"author\" content=\"Liam\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:site\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Liam\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-use-multiple-condition-checking-in-sql-using-case-when-then-else-end\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-use-multiple-condition-checking-in-sql-using-case-when-then-else-end\/\"},\"author\":{\"name\":\"Liam\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/23786905eb7b377f45ddb01c17da7671\"},\"headline\":\"How to use multiple condition checking in SQL using Case When Then Else End?\",\"datePublished\":\"2024-03-15T18:30:23+00:00\",\"dateModified\":\"2024-03-21T15:12:35+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-use-multiple-condition-checking-in-sql-using-case-when-then-else-end\/\"},\"wordCount\":150,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-use-multiple-condition-checking-in-sql-using-case-when-then-else-end\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-to-use-multiple-condition-checking-in-sql-using-case-when-then-else-end\/\",\"name\":\"How to use multiple condition checking in SQL using Case When Then Else End? - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-15T18:30:23+00:00\",\"dateModified\":\"2024-03-21T15:12:35+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-use-multiple-condition-checking-in-sql-using-case-when-then-else-end\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-to-use-multiple-condition-checking-in-sql-using-case-when-then-else-end\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-use-multiple-condition-checking-in-sql-using-case-when-then-else-end\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to use multiple condition checking in SQL using Case When Then Else End?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"name\":\"Silicon Cloud Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\",\"name\":\"Silicon Cloud Blog\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"contentUrl\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"width\":1024,\"height\":1024,\"caption\":\"Silicon Cloud Blog\"},\"image\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\",\"https:\/\/twitter.com\/SiliCloudGlobal\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/23786905eb7b377f45ddb01c17da7671\",\"name\":\"Liam\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8d37ed3e7f770dde8bf069ba0b4298688028c3abaacf1131742fc1352d174ebd?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8d37ed3e7f770dde8bf069ba0b4298688028c3abaacf1131742fc1352d174ebd?s=96&d=mm&r=g\",\"caption\":\"Liam\"},\"sameAs\":[\"http:\/\/Wilson\"],\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/liamwilson\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to use multiple condition checking in SQL using Case When Then Else End? - Blog - Silicon Cloud","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:\/\/www.silicloud.com\/blog\/how-to-use-multiple-condition-checking-in-sql-using-case-when-then-else-end\/","og_locale":"en_US","og_type":"article","og_title":"How to use multiple condition checking in SQL using Case When Then Else End?","og_description":"In SQL, you can use the CASE WHEN THEN ELSE END structure to make multiple condition judgments. The syntax is as follows: CASE WHEN condition1 THEN result1 WHEN condition2 THEN result2 ... ELSE result END The conditions such as condition1 and condition2 are expression conditions, while the results such as result1 and result2 are the [&hellip;]","og_url":"https:\/\/www.silicloud.com\/blog\/how-to-use-multiple-condition-checking-in-sql-using-case-when-then-else-end\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-15T18:30:23+00:00","article_modified_time":"2024-03-21T15:12:35+00:00","author":"Liam","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Liam","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-to-use-multiple-condition-checking-in-sql-using-case-when-then-else-end\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-use-multiple-condition-checking-in-sql-using-case-when-then-else-end\/"},"author":{"name":"Liam","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/23786905eb7b377f45ddb01c17da7671"},"headline":"How to use multiple condition checking in SQL using Case When Then Else End?","datePublished":"2024-03-15T18:30:23+00:00","dateModified":"2024-03-21T15:12:35+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-use-multiple-condition-checking-in-sql-using-case-when-then-else-end\/"},"wordCount":150,"commentCount":0,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-to-use-multiple-condition-checking-in-sql-using-case-when-then-else-end\/","url":"https:\/\/www.silicloud.com\/blog\/how-to-use-multiple-condition-checking-in-sql-using-case-when-then-else-end\/","name":"How to use multiple condition checking in SQL using Case When Then Else End? - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-15T18:30:23+00:00","dateModified":"2024-03-21T15:12:35+00:00","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-use-multiple-condition-checking-in-sql-using-case-when-then-else-end\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-to-use-multiple-condition-checking-in-sql-using-case-when-then-else-end\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-to-use-multiple-condition-checking-in-sql-using-case-when-then-else-end\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to use multiple condition checking in SQL using Case When Then Else End?"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/blog\/#website","url":"https:\/\/www.silicloud.com\/blog\/","name":"Silicon Cloud Blog","description":"","publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.silicloud.com\/blog\/#organization","name":"Silicon Cloud Blog","url":"https:\/\/www.silicloud.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","contentUrl":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","width":1024,"height":1024,"caption":"Silicon Cloud Blog"},"image":{"@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SiliCloudGlobal\/","https:\/\/twitter.com\/SiliCloudGlobal"]},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/23786905eb7b377f45ddb01c17da7671","name":"Liam","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8d37ed3e7f770dde8bf069ba0b4298688028c3abaacf1131742fc1352d174ebd?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8d37ed3e7f770dde8bf069ba0b4298688028c3abaacf1131742fc1352d174ebd?s=96&d=mm&r=g","caption":"Liam"},"sameAs":["http:\/\/Wilson"],"url":"https:\/\/www.silicloud.com\/blog\/author\/liamwilson\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/19232","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/users\/12"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=19232"}],"version-history":[{"count":1,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/19232\/revisions"}],"predecessor-version":[{"id":52964,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/19232\/revisions\/52964"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=19232"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=19232"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=19232"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}