mysql - sql查询返回错误结果

Question

为什么此查询返回 companyVisible 为 0 的结果，即使我只询问 companyVisible 值为 1 的公司？

SELECT c.companyID, c.companyDescription , c.companyName ,c.copmanyDrastiriotita, c.companyVisible
FROM company c
WHERE c.companyVisible = 1
AND c.companyDescription LIKE '%Keyword%'
OR c.companyName LIKE '%Keyword%'
OR c.copmanyDrastiriotita LIKE '%Keyword%'

Answer 1

AND 位于OR 之前，因此您需要添加括号。

SELECT c.companyID, c.companyDescription , c.companyName ,c.copmanyDrastiriotita, c.companyVisible
FROM company c
WHERE c.companyVisible = 1
AND (c.companyDescription LIKE '%Keyword%'
     OR c.companyName LIKE '%Keyword%'
     OR c.copmanyDrastiriotita LIKE '%Keyword%')