mysql:
oracle:
SELECT REGEXP_SUBSTR('aaa,bbbb,cccc,dd,eeee', '[^,]+', 1, rownum) from dual
connect by level <= LENGTH(regexp_replace('aaa,bbbb,cccc,dd,eeee', '[^,]+', ''))+1
mysql:
oracle:
SELECT REGEXP_SUBSTR('aaa,bbbb,cccc,dd,eeee', '[^,]+', 1, rownum) from dual
connect by level <= LENGTH(regexp_replace('aaa,bbbb,cccc,dd,eeee', '[^,]+', ''))+1