mysql null condition code example

Example: mysql select default if null

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