mysql if 0 then null code example

Example: mysql select default if null

IFNULL(MAX(EMAIL), "[email protected]") as email