[讨论]如何实现象google百度那样的模糊查询?
如题,想要实现输入“关键字+空格+关键字”的查询方式,该如何实现呢?是不是先判断有无空白字,然后再用Replace()实现呢? ![](images/smilies/emot/em01.gif)
麻烦解释一下吧,谢谢了!有点看晕了
我觉得应该是这样的:
key=replace(replace(replace(replace(replace(replace(replace(request(keywords)," ","")," ","")," ","")," ","")," ","")," ","")," ","") '尽可能把多余的空格替换掉
words=split(request(keywords)," ") '把输入的关键字按空格断成书组
sql="select * from table where 字段 like '%"&key&"%'" '先给一个条件 什么条件都行
for i= 0 to ubound(words) '把数组循环取出
sql=sql&" or 字段 like '%"&words(i)&"%'"
next
rs.open sql,conn,1,1
这样就可以了!
如果人家输入:手机 飞利浦(中间只有一个空格),那key就没有空格了,key="手机飞利浦",还怎么分割啊?!