Re: User defined variable in the stored function

[Alex Graham]

I dont need to use SELECT in the function, all I want to use is the stuff something like that
---
SET @myjson = '[[1, 14, 6], [15, 31, 6], [1, 14, 7], [15, 31, 7]]';
SET @month1=JSON_EXTRACT(@myjson, CONCAT('$[',j,'][2]'));
SET @fromdate=JSON_EXTRACT(@myjson, CONCAT('$[',j,'][0]'));
SET @todate=JSON_EXTRACT(@myjson, CONCAT('$[',j,'][1]'));
---
I also tried to use CHAR datatype for in the stored function, but no success.
It there a way to transfer @myjson from stored procedure to stored function?