Question

在ASP中如何进行模糊查询并高亮显示类似的结果出来

我要进行关键字的查询，然后向baidu那样把结果显示为红色显示出来。请给个例子我好分析，回答后加分

Answer 1

假设数据库为aaa，关键字为bbb 查询子段为title
set rs=server.createobject("adodb.recordset")
sql="select id,title from aaa where title like '%bbb%'"
rs.open sql,conn,1,1
do while not rs.eof
title=rs("title")
title=replace(title,"bbb","<font color=red>bbb</font>")
response.write "<a href=list.asp?id="&rs("id")&" target=_blank>"&title&"</a>"
rs.movenext
loop
rs.close
conn.close