---

{ “title”: “IFNULL”, “language”: “en”, “description”: “If the value of is not NULL, returns ; otherwise, returns .” }

Description

If the value of <expr1> is not NULL, returns <expr1>; otherwise, returns <expr2>.

Alias

• NVL

Syntax

IFNULL(<expr1>, <expr2>)

Parameters

• <expr1>: The expression to be checked for NULL.
• <expr2>: The value to return if <expr1> is NULL.

Return Value

• If <expr1> is not NULL, returns <expr1>.
• Otherwise, returns <expr2>.

Examples

1. Example 1

   SELECT IFNULL(1, 0);
   

   +--------------+
   | IFNULL(1, 0) |
   +--------------+
   |            1 |
   +--------------+
   

2. Example 2

   SELECT IFNULL(NULL, 10);
   

   +------------------+
   | IFNULL(NULL, 10) |
   +------------------+
   |               10 |
   +------------------+
   

3. Both arguments are NULL

   SELECT IFNULL(NULL, NULL);
   

   +--------------------+
   | IFNULL(NULL, NULL) |
   +--------------------+
   |               NULL |
   +--------------------+