记录:
武林外传 busiPro01
武林外传 busiPro02
武林外传 busiPro03
---------------------------
想要结果:
武林外传 busiPro01,busiPro02,busiPro03
武林外传 busiPro01
武林外传 busiPro02
武林外传 busiPro03
---------------------------
想要结果:
武林外传 busiPro01,busiPro02,busiPro03
但略有小问题:顺序现在结果:
武林外传 busiPro03,busiPro02,busiPro01
想要:
武林外传 busiPro01,busiPro02,busiPro03
select field1,reverse(group_concat(field2)) from tb_name group by field1;