MySQL 取生日段

SELECT*,(CASEWHEN d < CURRENT_DATE THEN- 1WHEN d = CURRENT_DATE THEN0WHEN d > CURRENT_DATE THEN1END) AS xFROM(SELECTid,user_name,real_name,user_level,birthday,positions,(CASEWHEN MONTH (CURRENT_DATE) = 12AND MONTH (birthday) = 1 THENDATE_ADD(d, INTERVAL + 1 YEAR)WHEN MONTH (CURRENT_DATE) = 1AND MONTH (birthday) = 12 THENDATE_ADD(d, INTERVAL - 1 YEAR)ELSEdEND) dFROM(SELECT*, STR_TO_DATE(REPLACE (DATE_FORMAT(birthday, '%Y-%m-%d'),YEAR (birthday),YEAR (CURRENT_DATE)),'%Y-%m-%d') dFROMuser_info) t1) t2WHEREt2.d BETWEEN ADDDATE(CURRENT_DATE, - 30)AND ADDDATE(CURRENT_DATE, 30)ORDER BYx ASC,t2.d ASC