mysql自定义split存储过程
drop PROCEDURE if exists procedure_split; CREATE PROCEDURE `procedure_split`( inputstring varchar(1000), delim char(1) ) begin declare strlen int DEFAULT length(inputstring); declare last_index int DEFAULT 0; declare cur_index int DEFAULT 1; declare cur_char VARCHAR(200); declare len int; drop temporary table if exists splittable; create TEMPORARY table splittable( value VARCHAR(20) ) ; WHILE(cur_index<=strlen) DO begin if substring(inputstring from cur_index for 1)=delim or cur_index=strlen then set len=cur_index-last_index-1; if cur_index=strlen then set len=len+1; end if; insert into splittable(`value`)values(substring(inputstring from (last_index+1) for len)); set last_index=cur_index; end if; set cur_index=cur_index+1; END; end while; end ;
调用
call PROCEDURE_split('中国,开源,社区',','); select * from splittable;