You are viewing the archived documentation of TiDB, which no longer receives updates.View latest LTS version docs ↗
Sign InStart for Free
TiDB Self-Managed
Sign InStart for Free

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