sqlite - SQLite WHERE子句被忽略

Question

我有一个非常简单的查询，该查询返回的结果我很确定不应该包括在内。

CREATE TABLE hits
AS SELECT *
FROM deduped_table
WHERE Bank LIKE '%monex%' OR Bank LIKE '%cibanco%' OR Bank LIKE '%intercam%'
AND (Bank_Country = 'US' OR Bank_Country = 'United States');

当我查看命中表时，Bank_Country列的结果不是“ US”或“ United States”。为什么？

Answer 1

加上括号以显示SQL's precedence rules，您的查询是：

SELECT *
FROM deduped_table
WHERE Bank LIKE '%monex%'
   OR Bank LIKE '%cibanco%'
   OR (Bank LIKE '%intercam%' AND
       (Bank_Country = 'US' OR Bank_Country = 'United States'));