SQL Function Reference

IFNULL

Returns the value passed by the 1st argument if it is not NULL. Otherwise, returns the value passed by the second argument.

MySQL

IFNULL(value, alternative_value)

value

The return value if it is not NULL

alternative_value

Alternative value if the value in the first argument was NULL

Examples

MySQL

SELECT IFNULL(NULL, "Alternative value");