mysql like if null code example

Example: mysql select default if null

IFNULL(MAX(EMAIL), "example@google.com") as email