This article is tagged with:
W3schools case when sql oracle
and mysql
w3schools case when sql oracle
CASE
   WHEN condition1 THEN result1
  Â
WHEN condition2 THEN result2
   WHEN
conditionN THEN resultN
   ELSE result
END;