获取最近3个月没有访问过的数据 - fetch the data who's is not visited since last 3 month

fetch the data who's is not visited since last 3 month

本文关键字：访问数据最近 3个获取 | 更新日期: 2023-09-27

这是我的查询

    SELECT customer.*, feedback.*, feedback.id as fid
    FROM feedback
    JOIN customer ON customer.feedbackID = feedback.id
    WHERE feedback.Overall_rating !=  ''
    AND `feedback.fb_date != '2015-05-07' 
AND feedback.fb_date != '2015-08-05'

我的问题是:我如何获取谁在3个月前至少访问过一次，之后没有访问过的数据。

Sorry for my English

如果你完全依赖于某个"fb_date"，你可以使用where子句:

feedback.fb_date < (CURDATE() - INTERVAL 3 MONTH)

为了澄清，这将使查询:

SELECT customer.*, feedback.*, feedback.id as fid
FROM feedback
JOIN customer ON `customer`.`feedbackID` = feedback.id
WHERE feedback.Overall_rating !=  ''
AND feedback.fb_date < (CURDATE() - INTERVAL 3 MONTH)

feedback.fb_date需要是DATE列类型才能工作。

如果我正确理解了问题，您可以使用像last_visit_date <现在是90天。您有访问last_visit_date的权限吗?>