mysql 按符号分隔符

-- 使用SUBSTRING_INDEX函数
SELECT SUBSTRING_INDEX('apple,banana,orange', ',', 1) AS part1,
       SUBSTRING_INDEX(SUBSTRING_INDEX('apple,banana,orange', ',', 2), ',', -1) AS part2,
       SUBSTRING_INDEX('apple,banana,orange', ',', -1) AS part3;

-- 使用FIND_IN_SET函数
SELECT * FROM (
    SELECT 'apple' AS value
    UNION ALL SELECT 'banana'
    UNION ALL SELECT 'orange'
) AS t
WHERE FIND_IN_SET('banana', 'apple,banana,orange');

-- 假设字段值为 'apple,orange,banana'
SELECT SUBSTRING_INDEX('apple,"orange,banana"', ',', 1) AS part1,
       SUBSTRING_INDEX(SUBSTRING_INDEX('apple,"orange,banana"', ',', 2), ',', -1) AS part2;