mysql 存储逗号分割存储好吗,使用mysql变量保存逗号分隔的值，以用于where in子句...

I have to run a query like this (query 1) -

select something from sometable where someId in (1,2,3)

I would like to keep a variable for the IDs part, like this (query 2) -

set @myIds = "1,2,3";

select something from sometable where someId in (@myIds);

But this does not give the expected result (gives an empty result set), and no query error as well.

I checked that if I wrap the comma separated IDs inside quotes, the query results an empty result set (query 3) -

select something from sometable where someId in ("1,2,3");

I guess when I am using variable @myIds like I showed above (query 2), it is evaluating to the above query (query 3).

解决方案

You need to have a dynamic sql on this,

SET @myIds = '1,2,3';

SET @sql = CONCAT('select something from sometable where someId in (',@myIds,')');

PREPARE stmt FROM @sql;

EXECUTE stmt;

DEALLOCATE PREPARE stmt;