CASE statement

Is it possible to make a CASE statement attibuting the same label to a WHEN result using ‘OR’?
Something like:

WHEN name = John OR name = Mary THEN ‘family’
ELSE ‘friend’
FROM table;

Seems its possible to use in keyword:

Some programming languages do support the feature you ask for, general is called/name: case fall through. So something like mysql case fall through is worth googling if you want to do some more research

1 Like

Actually that sintaxe can be done. I tried on the exercise and it worked. Thanks for your answer.
I will try the way you suggested.