php - 检查在 mysql startdate enddate 列之间找到的日期 renge

Question

在我的数据库中有两列和如下数据

   StartDate      Enddate
   2015-10-01     2015-10-30
   2015-10-15     2015-11-15
   2015-09-15     2015-10-15

如果我搜索 startdat :​​ 2015-10-16 Enddate : 2015-10-20 而不是想要以上所有结果，请帮助我

我的查询如下

Select * from campaign as c LEFT JOIN campaign_team as t ON c.campaign_id=t.campaign_id where t.user_id
  ='6' and 
(campaign_sdate BETWEEN '2015-10-16' AND '2015-10-20' or campaign_edate BETWEEN '2015-10-16' AND '2015-10-20'
 or ( campaign_sdate <= 2015-10-16 and campaign_edate >= 2015-10-20 ) );

提前致谢

Answer 1

你写了相反的条件

or ( campaign_sdate >= 2015-10-16 and campaign_edate <= 2015-10-20 ) );

当你使用它时删除 BETWEEN。

最终查询，

Select * from campaign as c LEFT JOIN campaign_team as t ON c.campaign_id=t.campaign_id where t.user_id
='6' or ( campaign_sdate >= 2015-10-16 and campaign_edate <= 2015-10-20 ) );