Navigation: Function Index > I
IFNULL
(IFNULL(arg1,arg2,arg3))
If arg1 is null, then the value of arg2 is returned. If arg1 is not null, then the value of arg3 is returned.
The IFNULL function does not recognize the value of zero (0) as NULL, even if ZERO is set ON.