当前位置：网站首页>MySQL comma separated data for branches

MySQL comma separated data for branches

2022-07-19 05:36:00 【Lun Zhi】

select
substring_index(substring_index(a.associate_host_ids,',',b.help_topic_id+1),',',-1) as id
from
platform_security_inciden a
join mysql.help_topic b on b.help_topic_id < (length(a.associate_host_ids) - length(replace(a.associate_host_ids,',',''))+1)
order by a.id

原网站

版权声明
本文为[Lun Zhi]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/200/202207170508072555.html