SQL NULL Functions

Below given are the SQL NULL functions

ISNULL()
NVL()
IFNULL()
COALESCE()

We can use these function to manage the null values .

mysql> SELECT 1+IFNULL(age,0) as age  FROM users ;
+—–+
| age |
+—–+
|   1 |
|   1 |
|   1 |
|   1 |
|   1 |
+—–+
5 rows in set (0.00 sec)

Share