SELECT * FROM hygl_member m
WHERE 1=1
AND DATE_FORMAT(m.`BIRTHDAY_B`,'%m-%d')>=DATE_FORMAT('2014-01-13','%m-%d')
AND DATE_FORMAT(m.`BIRTHDAY_B`,'%m-%d')<=DATE_FORMAT('2014-01-20','%m-%d')
mysql选取指定月份的数据
最新推荐文章于 2024-07-17 04:43:00 发布
SELECT * FROM hygl_member m
WHERE 1=1
AND DATE_FORMAT(m.`BIRTHDAY_B`,'%m-%d')>=DATE_FORMAT('2014-01-13','%m-%d')
AND DATE_FORMAT(m.`BIRTHDAY_B`,'%m-%d')<=DATE_FORMAT('2014-01-20','%m-%d')