mysql - SQL查询没有得到正确的支付方式

Question

我在使用 paymentmethod 1 执行我的 sql 查询时遇到问题显示它也显示 paymentmethod 3。请检查我哪里错了。提前致谢

这是我的 sql 查询:-

SELECT (SELECT COUNT(u.`upperuserid`) 
         FROM user u 
         WHERE u.upperuserid = user.usernewid 
     ) as ref,
       usernewid,
       user.paymentmethod,usersecond, mod_date
from user 
HAVING ref <  2 or user.usersecond=0 and paymentmethod = 1

Answer 1

ref <  2 or user.usersecond=0 and paymentmethod = 1

Operator precedence .这被解释为:

(ref <  2) or (user.usersecond=0 and paymentmethod = 1)

因为有问题的记录匹配 ref < 2 , 它们被返回。

通过在括号中对表达式进行分组来明确定义逻辑的优先级:

(ref <  2 or user.usersecond=0) and (paymentmethod = 1)