如图所示：想转成三行数据，两个字段，fassgrp, fvalue ,
select
t1.com,
left(t1.com,instr(t1.com,':')-1) as e,
mid(t1.com,instr(t1.com,':')+1,50) as e2
from (
substring_index(
t.com,
',',
b.help_topic_id + 1
),
',' ,- 1
) AS com
select 'f005:13466664685,f0006:3667477,f0008:3555' as com
) t
JOIN mysql.help_topic b ON b.help_topic_id < (
length(t.com) - length(
REPLACE (t.com, ',', '')) + 1)
) t1
1min目标场景问卷
立即参与
