Skip to main content
Version: 3.2

ifnull

Description​

If expr1 is NULL, returns expr2. If expr1 is not NULL, returns expr1.

Syntax​

ifnull(expr1,expr2);

Parameters​

expr1 and expr2 must be compatible in data type.

Return value​

The return value has the same type as expr1.

Examples​

mysql> select ifnull(2,4);
+--------------+
| ifnull(2, 4) |
+--------------+
|            2 |
+--------------+

mysql> select ifnull(NULL,2);
+-----------------+
| ifnull(NULL, 2) |
+-----------------+
|               2 |
+-----------------+
1 row in set (0.01 sec)