MySQL 查询本周过生日的人
select *from STUDENTwhere MID(student_age, 6, 5) in(MID(date_sub(curdate(), INTERVAL WEEKDAY(curdate()) + 1 DAY), 6, 5),MID(date_sub(curdate(), INTERVAL WEEKDAY(curdate()) + 0 DAY), 6, 5),MID(date_sub(curdate(), INTERVAL WEEKDAY(curdate()) - 1 DAY), 6, 5),MID(date_sub(curdate(), INTERVAL WEEKDAY(curdate()) - 2 DAY), 6, 5),MID(date_sub(curdate(), INTERVAL WEEKDAY(curdate()) - 3 DAY), 6, 5),MID(date_sub(curdate(), INTERVAL WEEKDAY(curdate()) - 4 DAY), 6, 5),MID(date_sub(curdate(), INTERVAL WEEKDAY(curdate()) - 5 DAY), 6, 5));
网上的都是扯淡,都有问题,我这个应该是终极方案,但是有点拖沓,这个需要解决。
欢迎提出更终极的解法。
如果觉得《MySQL-查询本周过生日的人-终极答案》对你有帮助,请点赞、收藏,并留下你的观点哦!