CASE value WHEN compare_value THEN result [WHEN compare_value THEN result ...] [ELSE result] END

CASE value WHEN compare_value THEN result [WHEN compare_value THEN result ...] [ELSE result] END

Syntax

MYSQL Copy

SELECT CASE 1 WHEN 1 THEN 'one'
    WHEN 2 THEN 'two' ELSE 'more' END;
'one'
SELECT CASE WHEN 1>0 THEN 'true' ELSE 'false' END;
'true'
SELECT CASE BINARY 'B'
    WHEN 'a' THEN 1 WHEN 'b' THEN 2 END;
NULL

Examples

Example

CASE WHEN condition THEN result [WHEN condition THEN result ...] [ELSE result] END

MYSQL Copy

SELECT CASE 1 WHEN 1 THEN 'one'
    WHEN 2 THEN 'two' ELSE 'more' END;
'one'
SELECT CASE WHEN 1>0 THEN 'true' ELSE 'false' END;
'true'
SELECT CASE BINARY 'B'
    WHEN 'a' THEN 1 WHEN 'b' THEN 2 END;
NULL