有一个表field1 field2
1 a
1 b
1 c
我想得到这样的结果field1 field2 field3 field4
1 a b cgroup_concat 只能实现
field1 field2
1 a b c有人知道吗?高飞回报
1 a
1 b
1 c
我想得到这样的结果field1 field2 field3 field4
1 a b cgroup_concat 只能实现
field1 field2
1 a b c有人知道吗?高飞回报
field1,
reverse(substring_index(reverse(substring_index(field2,',',1)),',',1)) as field2,
reverse(substring_index(reverse(substring_index(field2,',',2)),',',1)) as field3,
reverse(substring_index(reverse(substring_index(field2,',',3)),',',1)) as field4
from
(
select field1,group_concat(field2) as field2 from t2 group by field1
) T;