mysql字符串拆分实现split功能

栏目：云星空知识作者：金蝶来源：金蝶云社区发布：2024-09-16浏览：2

mysql字符串拆分实现split功能

https://blog.csdn.net/pjymyself/article/details/81668157

select

x.*

from apiresources x

inner join

(

select * from

(

SELECT SUBSTRING_INDEX(SUBSTRING_INDEX('1,7654,7698,7782,7788',',',help_topic_id+1),',',-1) AS Id

FROM mysql.help_topic

WHERE help_topic_id < LENGTH('1,7654,7698,7782,7788')-LENGTH(REPLACE(',7654,7698,7782,7788',',',''))+1

) z order by z.Id

) y on x.Id=y.Id

本文2024-09-16 18:38:22发表“云星空知识”栏目。
本文链接：https://wenku.my7c.com/article/kingdee-k3cloud-23431.html

阅读排行