How to pass a variable to a IN clause?

Posted by Thanu on Stack Overflow See other posts from Stack Overflow or by Thanu
Published on 2012-10-29T04:55:17Z Indexed on 2012/10/29 5:00 UTC
Read the original article Hit count: 93

Lets say I have a SP that has a SELECT statements as follows,

SELECT product_id, product_price FROM product 
WHERE product_type IN ('AA','BB','CC');

But data goes to that IN clause must be through a single variable that contains the string of values. Something link below

SELECT product_id, product_price FROM product 
WHERE product_type IN (input_variables);

But its not working that way. Any idea how to do this?

© Stack Overflow or respective owner

Related posts about mysql

Related posts about variables