oracle 和 mysql 字符串以逗号分割为多行

最近用到了将字符串以逗号分割为多行，就简简单单做个记录吧

 

oracle中将字符串以逗号分割为多行 :  

SELECT REGEXP_SUBSTR ('C32210627B0024-01-01,C32210628B0152-02-02', '[^,]+', 1,rownum)
from dual connect by rownum<=LENGTH ('C32210627B0024-01-01,C32210628B0152-02-02') -
LENGTH (regexp_replace('C32210627B0024-01-01,C32210628B0152-02-02', ',', ''))+1

 

 

 

mysql 中将字符串以逗号分割为多行

select substring_index(substring_index('1,2,3,4,5',',',help_topic_id+1),',',-1)
as Id from mysql.help_topic where help_topic_id<(length('1,2,3,4,5')-
length(replace('1,2,3,4,5',',',''))+1);