CASE statement

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


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


Seems its possible to use in keyword:

https://stackoverflow.com/questions/2120133/can-the-sql-case-statement-fall-through

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.