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
mysql字符串拆分实现split功能
https://blog.csdn.net/pjymyself/article/details/81668157select x.*from apiresources x inner join ( select * from ( SELECT S...
点击下载文档
本文2024-09-16 18:38:22发表“云星空知识”栏目。
本文链接：https://wenku.my7c.com/article/kingdee-k3cloud-23431.html
相关文章
您需要登录后才可以发表评论， 登录登录 或者 注册
最新文档
热门文章
