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

Question

I want to write something like

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

and also I want to use CASE WHEN FOR THIS.

O. Jones · Accepted Answer · 2017-06-09 22:40:56Z

1

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().

answered Jun 9, 2017 at 22:40

O. Jones

109k17 gold badges134 silver badges187 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1