mysql> select case2 when 1 then 'one'when 2 then 'two'else'more'end;+------------------------------------------------------------+| case2 when 1 then 'one'when 2 then 'two'else'more'end|+------------------------------------------------------------+| two |+------------------------------------------------------------+1 row in set (0.00 sec)
2.case when v1 then rv [when v2 then r2] else rn] end
mysql> select casewhen 1<0 then 'true'else'false'end;+--------------------------------------------+| casewhen 1<0 then 'true'else'false'end|+--------------------------------------------+| false |+--------------------------------------------+1 row in set (0.00 sec)