IFNULL

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