mysql 时间搜索年月日_mysql按时间查询（年/月/日）

0.创建表sql语句查询

mysql> show create table byzp_personinfo;

CREATE TABLE `byzp_personinfo` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`username` varchar(32) NOT NULL,

`birthday` date NOT NULL,

`create_data` datetime(6),

PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8 |

1.今天

select * from byzp_personinfo where to_days(birthday) <= to_days(now());

2.昨天

select * from byzp_personinfo where to_days(NOW()) - TO_DAYS(birthday) <= 1;

3.近7天

select * from byzp_personinfo where date_sub(CURDATE(),INTERVAL 7 DAY) <= DATE(birthday);

4.近30天

select * from byzp_personinfo where DATE_SUB(CURDATE(), INTERVAL 30 DAY) <= date(birthday);

5.本月

select * from byzp_personinfo WHERE DATE_FORMAT( birthday, '