MYSQL queries data today, yesterday, 7 days ago, 30 days, and this month, mysql days ago

MYSQL queries data today, yesterday, 7 days ago, 30 days, and this month, mysql days ago

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;

Seven days ago:

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

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 ');