First page Back Continue Last page Image

MySQL Branching Statements

CASE input_expression

WHEN when_expression_1 THEN result_expression_1

WHEN when_expression_2 THEN result_expression_2

ELSE else_result_expression

END

You can branch in MySQL, Both the CASE and IF Statements are supported

IF(test_expression, if_true_expression, else_expression)