I have a stored procedure that works:
call my_procedure('A,B,C,D');
I want to populate the A,B,C with a list from a subquery of another table, eg:
call my_procedure(
SELECT group_concat(letters) FROM table WHERE type = 'some_type')
);
Possible? Or am I doing it wrong?
SELECT my_function(group_concat(letters)) FROM table WHERE type = 'some_type';
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With