MySQL stored procedure parameters

Question

I want to grab x amount of items out of the DB, I was wondering if there was a way of passing some list of numbers to a stored procedure to be used with WHERE IN?

SELECT item_id, item_description
FROM items
WHERE item_id IN ( NEED_LIST_OF_IDS_HERE );

Should I not use a stored procedure for this query and just build up the sql in the application?

Or should I make a seperate DB call for each single item_id?

NOTE: items is not the actual name of the table, so dont bash me for a poor name choice, Im just hiding implementation.

Answer 1

All you doing is this single select? What's the point in wrapping it in stored procedure, then? Use prepared statement (do NOT build dynamic SQL) in your application and supply list of ids as parameter.