关于搜索的问题, 如我想搜索“我们”没问题,那么搜索“们我”时会找不到.
我的思路是把字都拆开,但sql语名如何定呀我用的是存贮过程如下:
public OleDbCommand GetSearchComm(string parameter1)
{
conn = new OleDbConnection(Global.GetUserProvider);
comm = new OleDbCommand();
comm.Connection = conn;
comm.CommandType = CommandType.StoredProcedure;
comm.CommandText = commandText;
comm.Parameters.Add("Parameter1",parameter1);
return comm;
}
相当于SQl语名:
SELECT * From GuestBook WHERE (GuestBook.Name) Like '%'+[@name]+'%';
我的思路是把字都拆开,但sql语名如何定呀我用的是存贮过程如下:
public OleDbCommand GetSearchComm(string parameter1)
{
conn = new OleDbConnection(Global.GetUserProvider);
comm = new OleDbCommand();
comm.Connection = conn;
comm.CommandType = CommandType.StoredProcedure;
comm.CommandText = commandText;
comm.Parameters.Add("Parameter1",parameter1);
return comm;
}
相当于SQl语名:
SELECT * From GuestBook WHERE (GuestBook.Name) Like '%'+[@name]+'%';
你得意思是定义多个关键字?
SELECT * From GuestBook WHERE (GuestBook.Name) Like '%我%' and like '%们%';
是呀?可sql语名如何定,关键字的字数又不确定
100mb 的!可以做论坛!才 50元!!速度飞快!
www.hi876.com 你们看看