Home MySQL Reference CASE WHEN

CASE WHEN

function

Conditional expression similar to if-else. Can be used in SELECT, WHERE, ORDER BY, and UPDATE.

Syntax

CASE WHEN condition THEN result ELSE default END

Example

sql

SELECT name,
    CASE
        WHEN age < 18 THEN 'Minor'
        WHEN age < 65 THEN 'Adult'
        ELSE 'Senior'
    END AS age_group
FROM users;

-- In ORDER BY
SELECT * FROM posts
ORDER BY CASE status
    WHEN 'featured' THEN 1
    WHEN 'published' THEN 2
    ELSE 3
END;

Date Functions

COALESCE() / IFNULL()