56,914
社区成员




传入 good_business = '1,2,3' 转化为 'a,b,c'
DELIMITER //
CREATE FUNCTION getDictListNameFor(counts INT ,good_business VARCHAR(50))
RETURNS VARCHAR(50)
BEGIN
DECLARE jieguo VARCHAR(50);
DECLARE i INT DEFAULT 1;
SET jieguo='';
WHILE i<=counts;
SELECT CONCAT_WS(',',jieguo,dictlist_name00) FROM basis_dict_list_info WHERE dictlist_code00=SUBSTRING_INDEX(SUBSTRING_INDEX(good_business,',',SET i),',',-1); //转化为 'a,b,c'
SET i=i+1;
END WHILE;
RETURN(jieguo);
END//
DELIMITER ;