62,072
社区成员
发帖
与我相关
我的任务
分享
string str = "a,b,c";
string[] a_str = str.Split();
string sql = "select * from tbname where 1=1";
string order = " order by id";
if (str!=""){
sql+=" and (";
order=")"+order;
}
for (int i=0;i<a_str.Length;i++){
if(i>0) sql+=" or ";
sql+=" title like '%"+a_str[i]+"%'";
}
sql+=order;