mysql分割字符串成数组

SELECT 
    SUBSTRING_INDEX(SUBSTRING_INDEX('apple,banana,orange', ',', n), ',', -1) AS fruit
FROM 
    (SELECT 1 AS n UNION ALL SELECT 2 UNION ALL SELECT 3) AS numbers
WHERE 
    n <= LENGTH('apple,banana,orange') - LENGTH(REPLACE('apple,banana,orange', ',', '')) + 1;

SELECT REGEXP_SUBSTR('apple|banana|orange', '[^|]+', 1, level) AS fruit
FROM dual
CONNECT BY REGEXP_SUBSTR('apple|banana|orange', '[^|]+', 1, level) IS NOT NULL;

SELECT 
    SUBSTRING_INDEX(SUBSTRING_INDEX('apple,banana,orange', ',', n), ',', -1) AS fruit
FROM 
    (SELECT 1 AS n UNION ALL SELECT 2 UNION ALL SELECT 3) AS numbers
ORDER BY n;

SELECT 
    SUBSTRING_INDEX(SUBSTRING_INDEX(REPLACE('apple,,banana,orange', ',,', ','), ',', n), ',', -1) AS fruit
FROM 
    (SELECT 1 AS n UNION ALL SELECT 2 UNION ALL SELECT 3) AS numbers
WHERE 
    n <= LENGTH(REPLACE('apple,,banana,orange', ',,', ',')) - LENGTH(REPLACE(REPLACE('apple,,banana,orange', ',,', ','), ',', '')) + 1;