现有一段字符串,如apple,banana,orange,pears,grape,要把它按照逗号(,)分割成: apple banana orange pears grape 然后使用...f_delimiter,i));
end while;
END$$
DELIMITER;
2、测试是否能成功分割
call splitString("apple,banana,orange,pears,grape...);
select * from tmp_split;
运行结果如下,说明分割成功:
mysql> call splitString("apple,banana,orange,pears,grape...affected
+--------+ | status | +--------+ | apple | | banana | | orange | | pears | | grape...mysql>
3、应用where in()查询
# 先传入字符串,分割后保存在临时表tmp_split中
call splitString("apple,banana,orange,pears,grape