mysql 将汉字转换成数字

CREATE TABLE numbers (
    id INT AUTO_INCREMENT PRIMARY KEY,
    description VARCHAR(255)
);

INSERT INTO numbers (description) VALUES ('一'), ('二'), ('三');

SELECT 
    id,
    CASE 
        WHEN description = '一' THEN 1
        WHEN description = '二' THEN 2
        WHEN description = '三' THEN 3
        -- 可以继续添加更多的汉字数字映射
        ELSE NULL
    END AS number
FROM numbers;

DELIMITER //

CREATE FUNCTION chinese_to_number(description VARCHAR(255)) RETURNS INT
BEGIN
    DECLARE number INT;
    CASE description
        WHEN '一' THEN SET number = 1;
        WHEN '二' THEN SET number = 2;
        WHEN '三' THEN SET number = 3;
        -- 可以继续添加更多的汉字数字映射
        ELSE SET number = NULL;
    END CASE;
    RETURN number;
END //

DELIMITER ;

SELECT id, chinese_to_number(description) AS number FROM numbers;