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

Query

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

Author: "adpit