IFNULL

Click to skip syntax diagram
Read syntax diagramSkip visual syntax diagram>>-IFNULL--(--expression--,--expression--)---------------------><
 

The IFNULL function returns the value of the first non-null expression.

The IFNULL function is identical to the COALESCE scalar function with two arguments. For more information, see COALESCE.

Example