CASE

Case expressions are used to evaluate a list of conditions and return one of multiple values.

Syntax

CASE condition_expression
     WHEN expression_value THEN result_expression
     WHEN expression_value THEN result_expression
     ELSE result_expression END