Flow Control MySQL

  1. Home
  2. MySQL
  3. Flow Control
  4. 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";