下面是我的数组:
set @fruit = 'apples,oranges,passion fruit,bananas,pineapples';如何将它们输出到单独的行中,即:
apples
oranges
passion fruit
bananas
pineapples谢谢。
发布于 2017-06-27 10:20:18
在我对this question的回答中,有一种创建函数和/或临时表的替代方法:
SELECT @i
, substring(@string, @start, @end-@start) str
FROM <BigTable>
, ( SELECT @string := 'apples,oranges,passion fruit,bananas,pineapples'
, @start := 0
, @end := 0
, @i := 0
, @len := length(@string)
, @n := @len-length(replace(@string,',',''))+1
) t
WHERE (@i := @i+1) <= @n
AND (@start := @end+1)
AND (@end := if((@loc:=locate(',',@string,@start))=0,@len+1,@loc))https://stackoverflow.com/questions/44771156
复制相似问题