mysql多个or条件和一个in的结果不同

Question

比如下面这两个的结果不一样是为什么：
--------------
SELECT * FROM order_info
WHERE order_from IN("mobile","Android","IOS","HTML5" )
AND add_time BETWEEN "2014-01-01 00:00:00" AND "2015-01-01 00:00:00";
-------------------------
SELECT * FROM order_info
WHERE order_from="mobile"
OR order_from="Android"
OR order_from="IOS"
OR order_from="HTML5"
AND add_time BETWEEN "2014-01-01 00:00:00" AND "2015-01-01 00:00:00";

Answer 1

因为你写的sql逻辑出问题了第二个应该这也写,or条件加上括号
SELECT * FROM order_info
WHERE (order_from="mobile"
OR order_from="Android"
OR order_from="IOS"
OR order_from="HTML5")
AND add_time BETWEEN "2014-01-01 00:00:00" AND "2015-01-01 00:00:00";追问

加括号就查询不到结果了