5.3.5 Control Flow Functions and Operators

The following table shows supported control flow operators. The VARLEN Support column identifies functions and operators that support variable-length encoded string columns. See Section 5.8.1.4, “Encoding String Columns”.

Table 5.4 Control Flow Functions and Operators

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

What's Next

Learn how to perform the following tasks:
- Run queries
- Modify tables
- Retrieve MySQL HeatWave Metadata
- Optimize workloads for OLAP and OLTP
- Monitor MySQL HeatWave processes