Name

ifnull() — Return first non-NULL argument

Common Usage

ifnull( param1, param2 )

Description

The ifnull() function is basically a fixed two-parameter version of coalesce(). If param1 is not NULL, it is returned. If param1 is NULL, param2 is returned.

See Also

coalesce(), nullif()