在mysql中将逗号分隔的字符串拆分成行

SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(str_column, ',', n), ',', -1) AS split_string
FROM str_table
CROSS JOIN (
    SELECT 1 AS n UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 -- 根据实际情况添加更多的数字
) AS numbers
WHERE n <= (LENGTH(str_column) - LENGTH(REPLACE(str_column, ',', ''))) + 1;

WITH RECURSIVE cte AS (
    SELECT 1 AS n, REGEXP_SUBSTR(str_column, '[^,]+', 1, 1) AS split_string
    FROM str_table
    UNION ALL
    SELECT n + 1, REGEXP_SUBSTR(str_column, '[^,]+', 1, n + 1)
    FROM cte
    WHERE REGEXP_SUBSTR(str_column, '[^,]+', 1, n + 1) IS NOT NULL
)
SELECT split_string
FROM cte;