MySql queries data for a specific period of time

MySql queries data for a specific period of time select * from wap_content where week (created_at) = week (now) If You Want To strictly require a certain year, you can query the data for one day at www.2cto.com as follows: select * from table where to_days (column_time) = to_days (now (); select * from table where date (column_time) = curdate (); query for one week: www.2cto.com select * from table where DATE_SUB (CURDATE (), INTERVAL 7 DAY) <= date (column_time); query a month: select * from table where DATE_SUB (CURDATE (), INTERVAL 1 MONTH) <= date (column_time );