查询当天生日的用户SELECT * FROM `t_users` WHERE MONTH(birthday) = MONTH(NOW()) and DAY(birthday) = DAY(NOW()) 版权声明：本文为Anenan原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接和本声明。原文链接：https://blog.csdn.net/Anenan/article/details/84827057