sql中的OR的使用求解,想查出该学校手机号不为NULL且不为"" 或 邮箱不为NULL且不为“”

Question

想查出该学校手机号不为NULL且不为"" 或 邮箱不为NULL且不为“”sql该怎么写？，以下这种是有问题的

 SELECT COUNT(1) FROM t_rm_user WHERE schoolCode = '612323'
AND (mobilePhone IS NOT NULL  AND  mobilePhone != "") OR (email IS NOT NULL AND email !="") 

Answer 1

SELECT COUNT(1) FROM t_rm_user WHERE schoolCode = '612323'
AND ((mobilePhone IS NOT NULL AND mobilePhone != "") OR (email IS NOT NULL AND email !="")) 这样写应该