· 7 years ago · Sep 19, 2018, 06:26 PM
1SELECT * FROM table WHERE id IN (GetChildren(36))
2
3CREATE TABLE test (
4 `ID` int(11) NOT NULL
5) ENGINE=InnoDB DEFAULT CHARSET=latin1;
6
7INSERT INTO test (ID) VALUES (1),(2),(3),(4);
8
9DELIMITER $$
10
11DROP FUNCTION IF EXISTS `TestFN` $$
12CREATE FUNCTION `TestFN` (GivenID VARCHAR(1024)) RETURNS varchar(1024) CHARSET latin1
13DETERMINISTIC
14BEGIN
15 RETURN '2,3,4';
16END $$
17DELIMITER ;