Re: excellent performance speed.

[Felix Geerinckx]

Roland Bouman wrote:

> select substring(substring_index(@v1:='yes,this,really,is ,fun',',',@n:=1),character_length(substring_index(@v1,',',@n-1))+1) c1
> -> ,substring(substring_index(@v1,',',@n:=@n+1),character_length(substring_index(@v1,',',@n-1))+2) c2
> -> ,substring(substring_index(@v1,',',@n:=@n+1),character_length(substring_index(@v1,',',@n-1))+2) c3
> -> ,substring(substring_index(@v1,',',@n:=@n+1),character_length(substring_index(@v1,',',@n-1))+2) c4
> -> ,substring(substring_index(@v1,',',@n:=@n+1),character_length(substring_index(@v1,',',@n-1))+2) c5
> -> ;

I prefer

SET @v1 := 'yes,this,really,is,fun';
select
substring_index(substring_index(@v1, ',', 1), ',', -1) c1,
substring_index(substring_index(@v1, ',', 2), ',', -1) c2,
substring_index(substring_index(@v1, ',', 3), ',', -1) c3,
substring_index(substring_index(@v1, ',', 4), ',', -1) c4,
substring_index(substring_index(@v1, ',', 5), ',', -1) c5
;

--
felix
Please use BBCode to format your messages in this forum.