16 lines (13 loc) · 1.2 KB

title

Control Flow Functions

summary

Learn about the Control Flow functions.

aliases

/docs/dev/functions-and-operators/control-flow-functions/

/docs/dev/reference/sql/functions-and-operators/control-flow-functions/

Control Flow Functions

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

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