mysql 根据生日算星座

SELECT 
    CASE 
        WHEN birth_date BETWEEN '2023-03-21' AND '2023-04-19' THEN '白羊座'
        WHEN birth_date BETWEEN '2023-04-20' AND '2023-05-20' THEN '金牛座'
        WHEN birth_date BETWEEN '2023-05-21' AND '2023-06-20' THEN '双子座'
        WHEN birth_date BETWEEN '2023-06-21' AND '2023-07-22' THEN '巨蟹座'
        WHEN birth_date BETWEEN '2023-07-23' AND '2023-08-22' THEN '狮子座'
        WHEN birth_date BETWEEN '2023-08-23' AND '2023-09-22' THEN '处女座'
        WHEN birth_date BETWEEN '2023-09-23' AND '2023-10-22' THEN '天秤座'
        WHEN birth_date BETWEEN '2023-10-23' AND '2023-11-21' THEN '天蝎座'
        WHEN birth_date BETWEEN '2023-11-22' AND '2023-12-21' THEN '射手座'
        WHEN birth_date BETWEEN '2023-12-22' AND '2024-01-19' THEN '摩羯座'
        WHEN birth_date BETWEEN '2024-01-20' AND '2024-02-18' THEN '水瓶座'
        WHEN birth_date BETWEEN '2024-02-19' AND '2024-03-20' THEN '双鱼座'
        ELSE '未知星座'
    END AS zodiac_sign
FROM users;