Can you loop over a comma separated list of values in a mysql stored procedure

I need t开发者_如何转开发o loop over a comma separated list of IDS that were passed into a stored procedure. I have seen people use locate() and substring etc but I haven't seen anything that really makes sense.

Thanks!

Maybe this is something like you want? http://forge.mysql.com/tools/tool.php?id=4

Basically it is used to convert a comma delimited string into a table.