mysql的max输入null_如果MySQL中返回的结果为NULL,请选择默认值

以下查询运行正常,但我想输入一个选项,如果返回的电子邮件是NULL,那么我输入“example@google.com”或类似的东西.我已经阅读了一些函数,比如COALESCE(EMAIL,“example@google.com”),但我不确定该函数在脚本中的位置.你能指点一下我应该在哪里注入这个功能吗？我是否正朝着正确的方向前进？谢谢.

SELECT LCASE(LOGIN_NAME) as uniqueid, CONCAT('sha-512:', PASSWD) as password, REPLACE(CONTACT_NAME, '"', '') as name, \

CONCAT('unit,', \

MAX(CASE WHEN USER_TYPE = 'custom' THEN \

'location_employee' \

WHEN (LOGIN_NAME != 'link' AND USER_TYPE = 'owner' AND (UA.PARTY_SITE_ID IS NULL OR NOT EXISTS (SELECT U2.ID FROM CUSTOMER_DATA.USER_ACCESS U2 WHERE U2.USER_ID=U.ID AND (U2.PARTY_SITE_ID IS NULL OR U2.PARTY_SITE_ID = '')) ) )THEN \

'master' \

ELSE \

'location' \

END)) AS role, \

MAX(EMAIL) as email, \

MAX(PHONE) as phone, \

MAX(FAX) as fax \

FROM ORACLE_EXPORTS.SHIP_TO ST, \

CUSTOMER_DATA.USER U \

JOIN CUSTOMER_DATA.USER_ACCESS UA ON U.ID = UA.USER_ID \

WHERE ( \

(UA.PARTY_SITE_ID IS NULL AND ST.CUSTOMER_ID = UA.CUSTOMER_ID ) \

OR \

(ST.PARTY_SITE_ID IS NOT NULL AND ST.PARTY_SITE_ID = UA.PARTY_SITE_ID ) \

) \

AND U.LOGIN_NAME IN ( ? ) \

GROUP BY LOGIN_NAME