MYSQL8 -如何通过定界符拆分动态长度字符串？

DELIMITER $$

CREATE PROCEDURE split_string(input_string VARCHAR(255), delimiter CHAR(1))
BEGIN
    DECLARE start_pos INT DEFAULT 1;
    DECLARE end_pos INT;
    DECLARE part VARCHAR(255);
    DECLARE result VARCHAR(255) DEFAULT '';

    WHILE start_pos > 0 DO
        SET end_pos = LOCATE(delimiter, input_string, start_pos);
        IF end_pos = 0 THEN
            SET end_pos = LENGTH(input_string) + 1;
        END IF;

        SET part = SUBSTRING(input_string, start_pos, end_pos - start_pos);
        SET result = CONCAT(result, part, ',');

        SET start_pos = end_pos + 1;
    END WHILE;

    SELECT TRIM(TRAILING ',' FROM result) AS output;
END$$

DELIMITER ;

CALL split_string('apple,banana,orange', ',');

+---------+
| output  |
+---------+
| apple   |
| banana  |
| orange  |
+---------+