CREATE DEFINER=`root`@`%` FUNCTION `vir`.`SPLIT_STR`(
x VARCHAR(1000), delim VARCHAR(12), pos INT) RETURNS varchar(1000) CHARSET utf8RETURN REPLACE(SUBSTRING(SUBSTRING_INDEX(x, delim, pos), LENGTH(SUBSTRING_INDEX(x, delim, pos -1)) + 1), delim, '')本文共 250 字，大约阅读时间需要 1 分钟。
CREATE DEFINER=`root`@`%` FUNCTION `vir`.`SPLIT_STR`(
x VARCHAR(1000), delim VARCHAR(12), pos INT) RETURNS varchar(1000) CHARSET utf8RETURN REPLACE(SUBSTRING(SUBSTRING_INDEX(x, delim, pos), LENGTH(SUBSTRING_INDEX(x, delim, pos -1)) + 1), delim, '')转载地址：http://aqhel.baihongyu.com/