mysql查询当天的所有信息: select * from test where year(regdate)=year(now()) and month(regdate)=month(now()) and day(regdate)=day(now()) 这个有一些繁琐,还有简单的写法: select * from table where date(regdate) = curdate();