how can i write several else in CASE When Clause in SELECT (MYSQL)?

Question

I want to write something like

if(?) x elseif(?) y else z

and also I want to use CASE WHEN FOR THIS.

And what trouble is that giving you? – TZHX Jun 09 '17 at 22:24 — TZHX, Jun 09 '17 at 22:24
Mysql manual describes the syntax for case. – Shadow Jun 09 '17 at 22:35 — Shadow, Jun 09 '17 at 22:35

score 1 · Accepted Answer · answered Jun 09 '17 at 22:40

MySql has IF(cond, true, false). You can nest them.

So you can do IF(a, x, IF(b, y, z)) for if(a) x elseif(b) y else z

You can also write

      CASE WHEN a THEN x
           WHEN b THEN y
                  ELSE z END

to do the same thing. Pretty straightforward. Some other makes of DBMS server use IIF() instead of IF().

1 Answers1