PopSQL
Case statements are useful when you're reaching for an if statement in your selectclause.
select
select id, name, category, unit_price, case when category = 5 then 'Premium' when category = 4 then 'Gold' when category = 3 then 'Standard' when category <= 2 then 'Basic' else 'unknown' end as quality_level from products;
Spread the word