MySQL Learning notes query today, yesterday, 7 days, nearly 30 days, month, last month data

Inquire

Today

The code is as follows	Copy Code
SELECT * FROM table name where To_days (Time field name) = To_days (now ());

Yesterday

The code is as follows	Copy Code
SELECT * FROM table name WHERE to_days (now ()) –to_days (Time field name) <= 1

7 days

The code is as follows	Copy Code
SELECT * FROM table name where Date_sub (Curdate (), INTERVAL 7 day) <= DATE (Time field name)

Nearly 30 days

The code is as follows	Copy Code
SELECT * FROM table name where Date_sub (Curdate (), INTERVAL Day) <= DATE (Time field name)

Month

The code is as follows	Copy Code
SELECT * FROM table name WHERE date_format (Time field name, '%y%m ') = Date_format (Curdate (), '%y%m ')

Last month

The code is as follows	Copy Code
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 related document