유리세계

SELECT DISTINCT TRIM(SUBSTRING_INDEX(SUBSTRING_INDEX(t._txt, '|', _num.n), '|', -1)) as split_txt
FROM (SELECT 1 as n union all SELECT 2 union all SELECT 3 union all SELECT 4 union all SELECT 5) _num
    INNER JOIN
    (SELECT '가나다|숫자|자르기|사과' as _txt) as t
;