MySQL Variable for IN clause

Question

I have a need to use a variable in my WHERE IN (@variable) clause because I have multiple and dynamic values being passed into my stored procedure variable. I've seen this done with MS SQL before by creating a function that will split the parameters but I'm not quite sure if that can be implemented on MySQL.

Is there anyway I can get this to work because I really don't have any other options?

Thanks

Answer 1

Maybe a FIND_IN_SET can help you.