是否有可能在MySql做之前和之后在同一语句中,我的数据变得太大,我想只显示有3个月的日期前和3个月后的数据"跟进"。这是我的声明。
select * from valuations
where Consultant = '$user'
and FollowedUp = 0 Order by FollowUp desc";
使用此代码
select * from valuations
where Consultant = '$user'
AND FollowUp >= NOW() - INTERVAL 3 MONTH
AND FollowUp <= NOW() + INTERVAL 3 MONTH
and FollowedUp = 0 Order by FollowUp desc";