Question

sql语句查询匹配数组怎么写

str=split(str,"|")str是一个数组怎么从数据库中查询id=数组的行

Answer 1

伪代码
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)

Answer 2

select * from database_table where id=array_value

Answer 3

用 where in