你可以做 像
SELECT username FROM table_name
WHERE MONTH(birthday)=MONTH('$birthday')
AND DAY(birthday)=DAY('$birthday')
SQL仅等于日期和月份,不等于年份
你可以做 像
SELECT username FROM table_name
WHERE MONTH(birthday)=MONTH('$birthday')
AND DAY(birthday)=DAY('$birthday')