Question

asp多字段查询语句

表DD，字段1 sheng，字段2 shi，字段3 id，查询关键字 key，查询条件：可能包含sheng和shi，或者只包含sheng或shi,比如：sheng=河北省，shi=石家庄，查询关键字为：河北省石家庄，或河北省，或石家庄，请问这样的查询语句该怎么写，谢谢
sheng=河北省或山东省或河南省等等
shi=石家庄或衡水或济南或郑州等等
关键字设为“Key”
shengid或shiid要不要用上？
骑车逛街的猪 我刚试了下，你的好像不能用，谢谢
炀凡 如果省市同时为关键字时就搜不出来了，谢谢
原代码：if sql_filter(Trim(Request.Form("key")))="" and key="" then
errinfo="<li>请输入搜索关键字！"
call showError()
else
if (not sql_filter(Trim(Request.Form("key")))="") and key="" then
Response.Redirect "?key="&Trim(Request.Form("key"))
Response.Flush
end if
end if
sql = "Select * from [表] where shi like '%"&key&"%' or sheng like '%"&key&"%'"
set rs=server.CreateObject("adodb.recordset")
rs.open sql,conn,1,1
if rs.eof or rs.bof then
rs.close
set rs=nothing
errinfo="在<font color=red>"&key&"</font>没有找到<br><a href=so.asp?act=s>请重新搜索</a>。"
call showError()
end if

Answer 1

sql = "select * from [表] where sheng+'省'+shi+'市' like '%" & keyword & "%'"

Answer 2

Sql = "SELECT * From DD Where sheng Like '%"&key&"%' or shi Like '%"&key&"%'"
Set Rs=Server.CreateObject("ADODB.RecordSet")
Rs.Open Sql,Conn,1,1

Answer 3

select * from [dd] where [sheng] = '河北省' or [shi] = '石家庄'

Answer 4

炀凡正解

Answer 5

用sql="select * from tabel1 where shang='%name%'"