不要用or
改用union all试试
select * from
(
select * from (select * from my_table where a = 1 and b = 'apple' and c >= 10000 and c <= 200000 and d >= '2014-10-10 12:59:10' order by d desc limit 40)a
union all
select * from (select * from my_table where a = 1 and b = 'android' and c >= 10000 and c <= 200000 and d >= '2014-10-10 12:59:10' order by d desc limit 40)b
)c
limit 40
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货