MySQL 8.0 Reference Manual Including MySQL NDB Cluster 8.0

12.5 Flow Control Functions

Table 12.7 Flow Control Operators

Name Description
CASE Case operator
IF() If/else construct
IFNULL() Null if/else construct
NULLIF() Return NULL if expr1 = expr2