Control Flow Functions

TiDB supports all of the control flow functions available in MySQL 5.7.

NameDescription
CASECase operator
IF()If/else construct
IFNULL()Null if/else construct
NULLIF()Return NULL if expr1 = expr2