MYSQL字符串排序,拆分排序组合函数
CREATE FUNCTION `stringAsc`(srcStr varchar(255)) RETURNS varchar(255) CHARSET utf8mb4
BEGIN
DECLARE result varchar(255) DEFAULT srcStr;
select GROUP_CONCAT(num ORDER BY num asc) INTO result from (
SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(srcStr,',',help_topic_id+1),',',-1) AS num
FROM mysql.help_topic
WHERE help_topic_id < LENGTH(srcStr)-LENGTH(REPLACE(srcStr,',',''))+1) t;
RETURN result;
END;