如何在SQL中将字符串月份名称转换为月份数字

SELECT 
    CASE 
        WHEN month_name = 'January' THEN 1
        WHEN month_name = 'February' THEN 2
        WHEN month_name = 'March' THEN 3
        WHEN month_name = 'April' THEN 4
        WHEN month_name = 'May' THEN 5
        WHEN month_name = 'June' THEN 6
        WHEN month_name = 'July' THEN 7
        WHEN month_name = 'August' THEN 8
        WHEN month_name = 'September' THEN 9
        WHEN month_name = 'October' THEN 10
        WHEN month_name = 'November' THEN 11
        WHEN month_name = 'December' THEN 12
    END AS month_number
FROM your_table;

SELECT MONTH(STR_TO_DATE(month_name, '%M')) AS month_number
FROM your_table;