IFNULL
The IFNULL function returns the value of the first non-null expression.
The IFNULL function is identical to the COALESCE scalar function with two arguments. For more information, see COALESCE.
Example
- When selecting the employee number (EMPNO) and salary (SALARY) from all
the rows in the EMPLOYEE table, if the salary is missing (that is, null),
then return a value of zero.
SELECT EMPNO, IFNULL(SALARY,0) FROM EMPLOYEE