mysql - 在 SQL 中迭代日期列

Question

这里是 MySQL 菜鸟。

我有这张表:

+-------------+-----------------------+
| business_id |     date_creation     |
+-------------+-----------------------+
| '3610'      | '2012-08-19 07:43:05' |
| '5020'      | '2012-08-18 03:38:51' |
| '5020'      | '2012-08-18 03:38:51' |
| '9491'      | '2017-08-18 06:52:52' |
| '10389'     | '2012-08-18 07:08:50' |
| ...         |                       |
+-------------+-----------------------+

我通过这个查询得到了这个:

SELECT
  citation.business_id,
  citation.date_creation
FROM citation,
     business
WHERE primary_activity_id = 850
AND business.id = citation.business_id;

但是，我只想过滤 2017 年以来的日期。

Answer 1

您可以像这样更新您的查询:

SELECT
  citation.business_id,
  citation.date_created
FROM citation,
     business
WHERE primary_activity_id = 850
AND business.id = citation.business_id
AND YEAR(citation.date_created) >= 2017;