问题描述

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

想查出该学校手机号不为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 !="")

解决方案

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

解决方案二：

SELECT COUNT(1) FROM t_rm_user WHERE schoolCode = '612323'
AND ISNULL(mobilePhone, '')!='' OR ISNULL(email, '')!=''