IFNULL

IFNULL(expr1,expr2)

Returns a result or default based on a test for NULL. (See also the NVL function.)