有一个语句比较模糊，是关于语句where条件有运算公式的问题

Question

for (int i = 0; i < 3; i++) { for (int j = 0; j < 3; j++) {string sql3 = "select id,state from [StockState] where id = '" + (100000 + 100 * i + j) + "' ";这上面是一个循环，这么写，查不出数据，请问后面id怎么写运算表达式啊

Answer 1

select * from a where b in(‘1’ , ‘2’, ‘3’) and c <> '4'
select * from a
where b like '%1%'
and b like '%2%'
and b like '%3%'
and c not like '%4%'