Mega Code Archive

 

Categories / MySQL / Function

 

Variants of CASE WHEN with no ELSE clause

mysql> mysql> SELECT CASE "ferret" WHEN "cat" THEN "meow" WHEN "dog" THEN "woof" END; +-----------------------------------------------------------------+ | CASE "ferret" WHEN "cat" THEN "meow" WHEN "dog" THEN "woof" END | +-----------------------------------------------------------------+ | NULL                                                            | +-----------------------------------------------------------------+ 1 row in set (0.00 sec) mysql> mysql> SELECT CASE WHEN 4=5 THEN "large value of 4" END AS "results"; +---------+ | results | +---------+ | NULL    | +---------+ 1 row in set (0.00 sec)