oracle 中的自定义函数迁移到mysql的问题

[咖啡加糖_]

对于这块不是很了解oralce中额函数如下
CREATE OR REPLACE FUNCTION "GET_ROMA_NUM_PY"(p_Index NUMBER)
RETURN NUMBER IS
v_rom_num_list TROMA_NUM_LIST := TROMA_NUM_LIST(
'1','2','3','4','5','6','7','8','9','10','','','','','','',
'1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20',
'1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20',
'1','2','3','4','5','6','7','8','9','10','','',
'1','2','3','4','5','6','7','8','9','10','','',
'1','2','3','4','5','6','7','8','9','10','11','12','',''
);
BEGIN
IF (p_Index>0) AND (p_Index<95) THEN
RETURN v_rom_num_list(p_Index);
ELSE
RETURN '';
END IF;
end get_roma_num_py;


清给位讲解下这个函数的作用，主要是
RETURN NUMBER IS
v_rom_num_list TROMA_NUM_LIST := TROMA_NUM_LIST(
'1','2','3','4','5','6','7','8','9','10','','','','','','',
'1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20',
'1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20',
'1','2','3','4','5','6','7','8','9','10','','',
'1','2','3','4','5','6','7','8','9','10','','',
'1','2','3','4','5','6','7','8','9','10','11','12','',''
);

如果改成mysql中的写法怎么写

感谢

[咖啡加糖_]

没人回答，结贴，我的解决方法是把那个集合存到表中然后去查表，没好办法只能那样做

[咖啡加糖_]

有人否......mysql中如何定义这个TROMA_NUM_LIST( '1','2','3','4','5','6','7','8','9','10','','','','','','', '1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20', '1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20', '1','2','3','4','5','6','7','8','9','10','','', '1','2','3','4','5','6','7','8','9','10','','', '1','2','3','4','5','6','7','8','9','10','11','12','','' );