如何将变量传递给 IN 子句?

2021-11-20 00:00:00 variables mysql in-clause stored-procedures

假设我有一个具有 SELECT 语句的 SP，如下所示，

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');

但是数据必须通过包含值字符串的单个变量传送到 IN 子句.下面有链接

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?

推荐答案

像这样传递参数值 - 'AA,BB,CC'.那么，使用FIND_IN_SET<就足够了/a> 函数 -

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);

相关文章