当使用 NOT LIKE 通配符时 MySQL 查询仍然返回值

Question

我有一个查询，其中我将通配符值与 NOT LIKE 结合使用，因为我正在查找公司名称的任何变体。我尝试将 NOT LIKE 部分移至 WHERE 语句的开头和 LIKE 语句之后，但结果中两者仍然返回 ABC Realty 或 ABC Realty, Inc. 的值？我错过了什么？

SELECT * 
FROM mytable
WHERE ListOfficeName NOT LIKE 'ABC Realty%' AND 
      MLSAreaMajor LIKE 'NA01%' OR MLSAreaMajor LIKE 'NA02%' OR
      MLSAreaMajor LIKE 'NA03%' OR MLSAreaMajor LIKE 'NA04%' OR 
      MLSAreaMajor LIKE 'NA05%' AND PhotoCount >= '1' AND 
      Longitude BETWEEN -89.69 AND -72.07 
ORDER BY ListPrice DESC

Answer 1

您必须使用括号来括起 WHERE 子句的所有 OR 谓词:

SELECT * 
FROM mytable
WHERE ListOfficeName NOT LIKE 'ABC Realty%' AND 
      (MLSAreaMajor LIKE 'NA01%' OR 
       MLSAreaMajor LIKE 'NA02%' OR 
       MLSAreaMajor LIKE 'NA03%' OR 
       MLSAreaMajor LIKE 'NA04%' OR 
       MLSAreaMajor LIKE 'NA05%') AND 
      PhotoCount >= '1' AND 
      Longitude BETWEEN -89.69 AND -72.07 
ORDER BY ListPrice DESC