1楼正解 2楼会出错 比如 select * from 顾客咨询表 where 姓名(...输)+(入...)咨询内容+咨询意向+备注 like '%输入%' 就会出错
1楼的正确。2楼的错误。实际上最好用自己定义函数来写(不用存储过程)select * from table where f(输入)=...
string s = this.textbox.text.trim(); for (int i = 0;i < s.length; i++) { string sql = " select * from 顾客咨询表 where 姓名 like '%" + s[i].ToString() + "%' or 咨询内容 like '%" + s[i].ToString() + "%' or 咨询意向 like '%" + s[i].ToString() + "%' or 备注 like '%" + s[i].ToString() + "%'"; }
也要使它能搜出来sql语句又当如何写
2楼会出错
比如
select * from 顾客咨询表 where 姓名(...输)+(入...)咨询内容+咨询意向+备注 like '%输入%'
就会出错
string s = this.textbox.text.trim();
for (int i = 0;i < s.length; i++)
{
string sql = " select * from 顾客咨询表 where 姓名 like '%" + s[i].ToString() + "%' or 咨询内容 like '%" + s[i].ToString() + "%' or 咨询意向 like '%" + s[i].ToString() + "%' or 备注 like '%" + s[i].ToString() + "%'";
}