Prepared Statement with in Clause

[Chris Aipperspach]

I'm trying to create a prepared statement with an in clause and have a few questions.

1. Is it easier to create two variable to hold the values?
2. Is there a better way to accomplish this?


PREPARE ProductQuery FROM 'select
prod.productname,prod.productline,count(prod.productCode) as counts
from
classicmodels.products prod where
prod.productline in (?)';

SET @pl = 'Classic Cars'',''Motorcycles';
EXECUTE ProductQuery USING @pl;

DEALLOCATE PREPARE ProductQuery;