mysql select null or default code example

Example: mysql select default if null

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