怎样同时搜索多个字段的关键字?
dim title
title=CSQL(request.form("search1"))
set rs=server.createobject("adodb.recordset")
exec="select * from shop where title like '%"&title&"%'"
rs.open exec,conn,1,1
if title="" then
response.write ("<script language=""javascript"">alert(""请输入搜索关键字!"");history.go(-1);</script>")
end if
这里只列出搜索title字段关键词的内容,怎样同时搜索出字段keywords,item的内容?