DROP FUNCTION if EXISTS Get_StrArrayStrOfIndex;
CREATE function Get_StrArrayStrOfIndex (str varchar(1024),split varchar(10),indexes INT)
returns varchar(1024)
begin
set @str=LTRIM(RTRIM(str));
set @start=1;
set @next=1;
set @seed=LENGTH(split);
set @split = split;
set @location = INSTR(@str,split);
while @location<>0 AND indexes>@next
DO
set @start=@location+@seed;
set @location=LOCATE(@split,@str,@start);
set @next=@next+1;
END WHILE;
if @location =0 then
set @location =LENGTH(@str)+1;
end if;
return substr(@str,@start,@location-@start);
end;
SELECT Get_StrArrayStrOfIndex('1,222,3,4,5,6',',',2)