strSubKey = Split(strKey, " ")
For i = 0 To UBound(strSubKey)
strSubKey=Mid(strKey,i,lngSubKey)
strNew1=strNew1 & " or Name like '%" & strSubKey(i) & "%'"
strNew2=strNew2 & " or salekeywords like '%" & strSubKey(i) & "%'"
Next
怎么才能输入“北京电子世界”时,按照“北京电子世界”、“北京”、“电子”、“世界”来查询(已经实现),输入"beijing dian zi shi jie"却可以按照"beijing","dian","zi","shi","jie"来查询(没有实现~~~~~~~~~~~~~~~~~~~~~~~~~~)。
下面的OR简单换成 and 也不行啊??
strSubKey = Split(strKey, " ")
For i = 0 To UBound(strSubKey)
strNew1=strNew1 & " and Name like '%" & strSubKey(i) & "%'"
strNew2=strNew2 & " and salekeywords like '%" & strSubKey(i) & "%'"
strNew3=strNew3 & " and title like '%" & strSubKey(i) & "%'"
Next
因为单字段和子串之间是and的关系,而3个字段之间是OR的关系啊,怎么搞定来实现精确查询呢??
(name like '%" & strSubKey(0) & "%' and name like '%" & strSubKey(1) & "%') or (salekeywords like '%" & strSubKey(0) & "%' and salekeywords like '%" & strSubKey(1) & "%') OR (title like '%" & strSubKey(0) & "%' and title like '%" & strSubKey(1) & "%')