谢谢,如果: select * from tablename where country like '%共和国%' 我想在“country”和“'%共和国%'”这两个地方都使用参数呢? 我原本的代码如下:(只能查到相等的) SELECT * FROM tablename WHERE " + param1 + @"= '" + param2 + @"' ORDER BY ID";
SELECT * FROM tablename WHERE " + param1 + @"like '%" + param2 + @"%' ORDER BY ID";
select * from tablename where country like '%共和国%'
我想在“country”和“'%共和国%'”这两个地方都使用参数呢?
我原本的代码如下:(只能查到相等的)
SELECT * FROM tablename WHERE " + param1 + @"= '" + param2 + @"'
ORDER BY ID";
ORDER BY ID";