Outdated Version
You are viewing an older version of this section. View current production version.
IFNULL
Returns the second argument if the first argument is NULL
, else returns the first argument.
Syntax
IFNULL (val1, val2)
Arguments
- Any SQL objects
Return Type
- Default return type is the more general of the two given expressions, val1 and val2, in the order of:
string
,real
, orinteger
.
Examples
memsql> select ifnull(NULL, 'plan b'), ifnull('plan a', 'plan b');
+------------------------+----------------------------+
| ifnull(NULL, 'plan b') | ifnull('plan a', 'plan b') |
+------------------------+----------------------------+
| plan b | plan a |
+------------------------+----------------------------+