(mysql.info.gz) CASE Statement

Info Catalog

(mysql.info.gz) IF Statement

(mysql.info.gz) Flow Control Constructs

(mysql.info.gz) LOOP Statement

 
 19.1.9.2 `CASE' Statement
 .........................
 
      CASE CASE_VALUE
          WHEN WHEN_VALUE THEN STATEMENT_LIST
          [WHEN WHEN_VALUE THEN STATEMENT_LIST ...]
          [ELSE STATEMENT_LIST]
      END CASE
 
 Or:
 
      CASE
          WHEN SEARCH_CONDITION THEN STATEMENT_LIST
          [WHEN SEARCH_CONDITION THEN STATEMENT_LIST ...]
          [ELSE STATEMENT_LIST]
      END CASE
 
 The `CASE' statement for stored procedures implements a complex
 conditional construct. If a SEARCH_CONDITION evaluates to true, the
 corresponding SQL statement is executed. If no search condition
 matches, the statement in the `ELSE' clause is executed.
 
 stored procedure differs slightly from that of the SQL `CASE'
 _expression_ described in  Control flow functions.  The `CASE'
 statement cannot have an `ELSE NULL' clause, and it is terminated with
 `END CASE' instead of `END'.
 

Info Catalog

(mysql.info.gz) IF Statement

(mysql.info.gz) Flow Control Constructs

(mysql.info.gz) LOOP Statement