SQL - Case

In SQL case works with either the select or update clauses. It provides when-then-else functionality (WHEN this_happens THEN do_this) also known as conditional statements.