mysql - 查询未返回预期结果

Question

我有这个问题:

 SELECT * FROM Sales 
 WHERE (Date BETWEEN '2017-01-01' AND '2017-02-28') 
   AND (ID="Search" OR Product="Search");

它应该只返回 ID os Product 等于搜索的这两个日期之间的销售额，但它返回这些日期之间的所有结果，即使 ID 或 product = Search，我不明白为什么

编辑

示例数据

ID      Date          Product
1       2017-01-11    Product A
2       2017-02-01    Product C
3       2017-02-05    Product B
4       2017-03-01    Product A

如果我的查询是

SELECT * FROM Sales 
WHERE (Date BETWEEN '2017-01-01' AND '2017-02-28') 
 AND (ID="Product C" OR Product="Product C");

我很期待

ID      Date          Product  
2       2017-02-01    Product C  

但它返回

ID      Date          Product  
1       2017-01-11    Product A  
2       2017-02-01    Product C  
3       2017-02-05    Product B  

提前致谢

Answer 1

没问题。例如，

我的 table


+----+------+--------------------+
|编号 |姓名 |创建时间 |
+----+------+--------------------+
| 1 | 1 | 2017-03-04 11:06:25 |
| 2 | 2 | 2017-03-04 11:09:27 |
| 3 | 4 | 2017-03-04 11:06:56 |
+----+------+--------------------+


我的数据库


从测试中选择 *
WHERE (create_at BETWEEN '2017-03-04 11:06:00' AND '2017-03-04 11:10:00')
AND (id="2"或 name="2");


我的结果


+----+------+--------------------+
|编号 |姓名 |创建时间 |
+----+------+--------------------+
| 2 | 2 | 2017-03-04 11:09:27 |
+----+------+--------------------+