如何抓取最近生日的人
如果想要抓取今天前後一週生日的人 SELECT * FROM customer t WHERE MOD(DAYOFYEAR(CURDATE()) - DAYOFYEAR(t.birth) + 365, 365) <= 7 OR MOD(DAYOFYEAR(t.birth) - DAYOFYEAR(CURDATE()) + 365, 365) <= 7 如果要抓取未來兩週生日的人 SELECT * FROM customer t WHERE MOD(DAYOFYEAR(t.birth) - DAYOFYEAR(CURDATE()) + 365, 365) <= 14 參考來源