mysql - (或where查询)的错误结果

Question

我的查询看起来像:

select *
from `games`
    inner join `prowizja` on `prowizja`.`id_gry` = `games`.`id`
where `games`.`status` = 2 and `games`.`winner_user_id` != 49
 and `games`.`owner_user_id` = 49 or `games`.`join_user_id` = 49

重要的是游戏。winner_user_id` != 49。但是我这个查询的结果是:

有人可以告诉我，为什么我会收到 winner_user_id 为 49 的结果，但我不想等于。谢谢

Answer 1

您可能必须将 WHERE 子句的最后两个谓词括在括号中:

select * 
from `games` 
inner join `prowizja` 
on `prowizja`.`id_gry` = `games`.`id`
where `games`.`status` = 2 and 
      `games`.`winner_user_id` != 49 and
      (`games`.`owner_user_id` = 49 or `games`.`join_user_id` = 49)