How to pass a variable to a IN clause?

Pass parameter value like this – 'AA,BB,CC'. Then, it is enough to use FIND_IN_SET function –

SELECT product_id, product_price
FROM product
WHERE FIND_IN_SET(product_type, param);