Mysql queries data today, yesterday, 7 days, last 30 days, this month, and last month

Mysql queries data today, yesterday, 7 days, last 30 days, this month, and last month

Today

SELECT * FROM table name WHERE TO_DAYS (time field name) = TO_DAYS (now ());

Yesterday

SELECT * FROM table name WHERE TO_DAYS (NOW ()-TO_DAYS (time field name) <= 1

7 days

SELECT * FROM table name WHERE DATE_SUB (CURDATE (), INTERVAL 7 DAY) <= date (time field name)

Last 30 days

SELECT * FROM table name WHERE DATE_SUB (CURDATE (), INTERVAL 30 DAY) <= date (time field name)

This month

SELECT * FROM table name WHERE DATE_FORMAT (time field name, '% Y % M') = DATE_FORMAT (CURDATE (),' % Y % M ')

Last month

SELECT * FROM table name WHERE PERIOD_DIFF (date_format (now (), '% Y % M'), date_format (time field name,' % Y % M') = 1