Mysql 的字符串的拼接 拆分循环

   

	# 查询得数据进行 拼接
	# group_concat(）
	#截取a,b,v,d  个数
	set @i = length(uids) - length(replace(uids,",",''))+1;  
	WHILE @i > 0 DO
			set @i = @i - 1;
			# 取最后一条记录
			set @str = SUBSTRING_INDEX(uids,',',-1);
			# 在原有数据中去除已经去除得
			set uids = replace(uids,CONCAT("," , @str),'');
			#SELECT @str;
	END WHILE;