Control Flow Functions
Built-In functions for assessing data to determine what results to return.
-
CASE OPERATOR
Returns the result where value=compare_value or for the first condition that is true. -
DECODE
Decrypts a string encoded with ENCODE(), or, in Oracle mode, matches expressions. -
DECODE_ORACLE
Synonym for the Oracle mode version of DECODE(). -
IF Function
If expr1 is TRUE, returns expr2; otherwise it returns expr3. -
IFNULL
Check whether an expression is NULL. -
NULLIF
Returns NULL if expr1 = expr2. -
NVL
Synonym for IFNULL. -
NVL2
Returns a value based on whether a specified expression is NULL or not.
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
