Question

关于ASP 模糊搜索的问题

gjz=trim(request.Form("sosuozi"))

sql="select * from xinxi where shenhe="& true & " and biaoti or neirong like ' %"&gjz&"%' order by shijian DESC"

为什么我一运行就全搜索出来了?相当于biaoti or neirong like ' %"&gjz&"%' order by shijian DESC"这句没起作用

shenhe字段是逻辑型 biaoti neirong这两个字段是字符型,shijian字段时日期型

Answer 1

sql="select * from xinxi where shenhe="& true & " and biaoti like ' %"&gjz&"%' and neirong like ' %"&gjz&"%' order by shijian DESC"

Answer 2

分开写！
biaoti like ' %"&gjz&"%' or neirong like ' %"&gjz&"%' order by shijian DESC"