[讨论]如何实现象google百度那样的模糊查询？ - ASP技术论坛

编程论坛 → WEB开发 → 『 ASP技术论坛』 → [讨论]如何实现象google百度那样的模糊查询？

标题：[讨论]如何实现象google百度那样的模糊查询？

只看楼主

肖走

等　级：新手上路
帖　子：85
专家分：0
注　册：2005-9-26

楼主

问题点数：0 回复次数：28

[讨论]如何实现象google百度那样的模糊查询？

如题，想要实现输入“关键字＋空格＋关键字”的查询方式，该如何实现呢？是不是先判断有无空白字，然后再用Replace()实现呢？

搜索更多相关主题的帖子: google　百度　模糊　查询　

2006-06-12 10:16

islet

等　级：贵宾
威　望：89
帖　子：6548
专家分：0
注　册：2005-1-28

第 2 楼

得分:0

key=replace(replace(replace(replace(replace(replace(replace(request(keywords)," ","")," ","")," ","")," ","")," ","")," ","")," ","")
words=split(key," ")
sql="select * from table where 字段 like '%"&key&"%'"
for i= 0 to ubound(words)-1
sql=sql&" or 字段 like '%"&words(i)&"%'"
next
rs.open sql,conn,1,1

">东搞一下西搞一下

2006-06-12 10:27

肖走

等　级：新手上路
帖　子：85
专家分：0
注　册：2005-9-26

第 3 楼

得分:0

以下是引用islet在2006-6-12 10:27:04的发言：
key=replace(replace(replace(replace(replace(replace(replace(request(keywords)," ","")," ","")," ","")," ","")," ","")," ","")," ","")
words=split(key," ")
sql="select * from table where 字段 like '%"&key&"%'"
for i= 0 to ubound(words)-1
sql=sql&" or 字段 like '%"&words(i)&"%'"
next
rs.open sql,conn,1,1

麻烦解释一下吧，谢谢了！有点看晕了

2006-06-12 10:39

islet

等　级：贵宾
威　望：89
帖　子：6548
专家分：0
注　册：2005-1-28

第 4 楼

得分:0

key=replace(replace(replace(replace(replace(replace(replace(request(keywords)," ","")," ","")," ","")," ","")," ","")," ","")," ","") '尽可能把多余的空格替换掉
words=split(key," ") '把输入的关键字按空格断成书组
sql="select * from table where 字段 like '%"&key&"%'" '先给一个条件什么条件都行
for i= 0 to ubound(words)-1 '把数组循环取出
sql=sql&" or 字段 like '%"&words(i)&"%'"
next
rs.open sql,conn,1,1

">东搞一下西搞一下

2006-06-12 10:51

hangxj