Use case when : CASE WHEN Select « Flow Control « SQL / MySQL

1. SQL / MySQL
2. Flow Control
3. CASE WHEN Select

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";

           
       

Related examples in the same category