Re: How to iterate trough list in string

[Rick James]

Things to try:
* send in the name of the temp table, then 'prepare' the query using a CONCAT to construct the query.
* If you have only thread on one client, then there is no ambiguity of temp table name, and the stored procedure could 'know' the name.

In a totally different approach, (ugly and limited):
SELECT @ids := GROUP_CONCAT(id SEPARATOR ',') FROM ... WHERE ...
Then pass the string @ids into the stored procedure, and construct (in the prepare) something like:
CONCAT('SELECT ... WHERE id IN (', ids, ')');

GROUP_CONCAT has a max string length.