Mysql Query data today, yesterday, 7 days, last 30 days, and this month _ MySQL

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

It is also a mysql technique to collect website document data today, yesterday, 7, last 30 days, and this month! Love micro network test successful!

It is also a mysql technique to collect website document data today, yesterday, 7, last 30 days, and this month! The test is successful.

['Date' datetime null default null comment 'Time ']

[Time type: 17:22:16]

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;

/* DATEDIFF (now (), FROM_UNIXTIME ('Time field name') = 1; // The Time field storage type is timestamp */

7 days

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

/* DATEDIFF (now (), FROM_UNIXTIME ('Time field name') = 7; // The Time field storage type is timestamp */

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

BitsCN.com