伪代码str = "1|2|3|4"str = str.Replace("|", ",");string sql = "select * FROM T where [abc] in (" + str + ")";就是select * from t where abc in (1,2,3,4)
select * from database_table where id=array_value