Control Flow Functions
Built-In functions for assessing data to determine what results to return.
| Title | Description |
|---|---|
| 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.
© 2021 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/control-flow-functions/