递归函数写法
CREATE FUNCTION dgsf (areaId VARCHAR(1000))
RETURNS VARCHAR(4000)
BEGIN
DECLARE sTemp VARCHAR(4000);
DECLARE sTempChd VARCHAR(4000);
SET sTemp = '$';
SET sTempChd = areaId;
WHILE sTempChd is not NULL DO
SET sTemp = CONCAT(sTemp,',',sTempChd);
SELECT group_concat(con_parent_unid) INTO sTempChd FROM fcp_uimp_allcontent where FIND_IN_SET(con_unid,sTempChd)>0;
END WHILE;
return sTemp;
END;
调用
select * from fcp_uimp_allcontent a where FIND_IN_SET(a.con_unid, dgsf('370,400'))