Question

asp的sql的like特定查询

<% dim a3
a3="时尚"
a31="休闲"
set r3 = server.CreateObject("ADODB.recordset")
s3 = "select top 5 * from content where name like '%"&a3&"%' and like '%"&a31&"% order by id desc"
r3.open s3,conn,1,1
%>

语法错误 (操作符丢失) 在查询表达式 'name like '%时尚%' and like '%休闲% order by id desc' 中。

要怎么设置呢？
还是错误，我改了
s3 = "select top 5 * from content where name like '%"&a3&"%' and like '%"&a31&"%' order by id desc"

语法错误 (操作符丢失) 在查询表达式 'name like '%时尚%' and like '%休闲%'' 中。

Answer 1

你掉了字段
and name like
另外,最好用[name],因为属于关键字

*************

like '%"&a31&"% order by

错了,少了一个'

like '%"&a31&"%' order by

Answer 2

第二个like没有参数
s3 = "select top 5 * from content where name like '%"&a3&"%' and name like '%"&a31&"%' order by id desc"

Answer 3

'%"&a31&"% '