php - mySql 之前和之后

Question

在 MySql 中是否可以在同一语句之前和之后执行操作，我的数据变得太大，我只想显示日期为“FollowUp”之前 3 个月和之后 3 个月的数据。它是日期时间列。这是我的声明..

select * from valuations 
            where Consultant = '$user'
            and FollowedUp = 0 Order by FollowUp desc"; 

Answer 1

使用此代码

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";