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