最近用到了将字符串以逗号分割为多行,就简简单单做个记录吧
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);
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步