获取最近10天过生日的sql

SELECT
*
FROM
demo
WHERE
DATEDIFF(
CAST(
CONCAT(
YEAR ('2023-12-27'),
DATE_FORMAT(birthday, '-%m-%d')
) AS DATE
),
CAST(
DATE_FORMAT('2023-12-27', '%y-%m-%d') AS DATE
)
) BETWEEN 0
AND 10
OR
DATEDIFF(
CAST(
CONCAT(
YEAR ('2023-12-27') + 1,
DATE_FORMAT(birthday, '-%m-%d')
) AS DATE
),
CAST(
DATE_FORMAT('2023-12-27', '%y-%m-%d') AS DATE
)
) BETWEEN 0
AND 10;