Mysql Study Notes query data of today, yesterday, 7 days, last 30 days, this month, and last month

Paste the study notes of a webmaster. The SQL statements include the data statements of today, yesterday, 7 days, last 30 days, this month, and last month. If you need them, you can refer to them.

Paste the study notes of a webmaster. The SQL statements include the data statements of today, yesterday, 7 days, last 30 days, this month, and last month. If you need them, you can refer to them.

Query

Today

The Code is as follows:
Select * from table name where to_days (time field name) = to_days (now ());

Yesterday

The Code is as follows:
SELECT * FROM table name WHERE TO_DAYS (NOW ()-TO_DAYS (time field name) <= 1

7 days

The Code is as follows:
SELECT * FROM table name where DATE_SUB (CURDATE (), INTERVAL 7 DAY) <= date (time field name)

Last 30 days

The Code is as follows:
SELECT * FROM table name where DATE_SUB (CURDATE (), INTERVAL 30 DAY) <= date (time field name)

This month

The Code is as follows:
SELECT * FROM table name WHERE DATE_FORMAT (time field name, '% Y % m') = DATE_FORMAT (CURDATE (),' % Y % m ')

Last month

The Code is as follows:
SELECT * FROM table name WHERE PERIOD_DIFF (date_format (now (), '% Y % m'), date_format (time field name,' % Y % m') = 1

At the same time, attach a mysql Official document