1,FUNCTION-1
CREATE FUNCTION `vendor_area_child_ids`(rootId INT)
RETURNS varchar(1000)
BEGIN
DECLARE pTemp VARCHAR(1000);
DECLARE cTemp VARCHAR(1000); SET pTemp = '$';
SET cTemp =cast(rootId as CHAR); WHILE cTemp is not null DO
SET pTemp = concat(pTemp,',',cTemp);
SELECT group_concat(id) INTO cTemp FROM pd_vendor_area WHERE FIND_IN_SET(parent_id,cTemp)>0;
END WHILE;
RETURN pTemp;
END;