如何查询标题中是否包含多个关键词？
vkey="AA,BB,CC"
我要查询包含这3个关键词的所有的标题， 该怎么做？
vvkey=split(vkey,",")
vvstr=""
for i=0 to ubound(vvkey)-1
vvstr=vvstr & "dtitle like '%"&vvkey(i)&"%' or"
next
select top 20 vtitle from vtxt where " vvstr " order by id desc
这样查询吗？
[解决办法]
<%
dim vkey,arr,sql
vkey="AA,BB,CC"
arr=split(vkey,",")
sql=""
for i=0 to ubound(arr)
sql=sql & "or dtitle like '%"&arr(i)&"%' "
next
Response.write mid(sql,3) '输出 dtitle like '%AA%' or dtitle like '%BB%' or dtitle like '%CC%'
%>
