Mega Code Archive

 

Categories / MySQL / Flow Control

 

Use case when

/* mysql>   SELECT CASE WHEN 9>7     ->                  THEN "TRUE"     ->                  ELSE     ->                  "FALSE"     ->                  END     ->   AS "Results"; +---------+ | Results | +---------+ | TRUE    | +---------+ 1 row in set (0.00 sec) */   SELECT CASE WHEN 9>7                   THEN "TRUE"                   ELSE                   "FALSE"                   END    AS "Results";