myqsl stored procedure passing comma seperated list as parameter

[udaypawar]

Hi All,

I have one problem here with mysql stored procedures.

I have a list of ids seperated by comma e.g., (" 'A', 'B', 'C' "). I am passing the same to mysql stored procedure as a parameter. I want to use these values in where clause of select statement using IN.

I can't use prepared statements because queries written in stored procedure are very complex.

[Turkill]

You could use a function to split the the string like one of these :
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=50648

The first one returns a table and you could query that table into the IN part of your query.

SELECT * FROM some_table WHERE id IN (SELECT id FROM func_table)