sql基于分隔符的可变数字拆分字符串

DELIMITER $$
CREATE FUNCTION split_string(input VARCHAR(255), delimiter VARCHAR(10), position INT)
RETURNS VARCHAR(255)
BEGIN
    DECLARE result VARCHAR(255);
    SET result = SUBSTRING_INDEX(input, delimiter, position);
    RETURN TRIM(BOTH delimiter FROM result);
END$$
DELIMITER ;

SELECT split_string('1,2,3,4,5', ',', 1) AS number1,
       split_string('1,2,3,4,5', ',', 2) AS number2,
       split_string('1,2,3,4,5', ',', 3) AS number3,
       split_string('1,2,3,4,5', ',', 4) AS number4,
       split_string('1,2,3,4,5', ',', 5) AS number5;

number1 | number2 | number3 | number4 | number5
--------|---------|---------|---------|---------
1       | 2       | 3       | 4       | 5

SELECT REGEXP_REPLACE(input, '[^0-9,]', '') AS numbers
FROM your_table;

SELECT REGEXP_REPLACE('1,2,3,4,5', '[^0-9,]', '') AS numbers;

numbers
-------
1,2,3,4,5