More than 3 years have passed since last update.

mysql 過去180日のデータ取得

Posted at 2019-07-20

日付を計算する場合

SELECT * FROM summary_tags
WHERE created_at BETWEEN (CURDATE() - INTERVAL 180 DAY) AND (CURDATE() + INTERVAL 1 DAY)
AND tag_id = 1473

interval xx dayは日付を表す
whereの条件はandで繋いでいく

SELECT * FROM summary_tags
WHERE created_at >= '2018-12-03 03:00:07'
AND tag_id = 1473

テーブル名、カラム名はただの事例
以上。