开发者

Could 'Match' & 'March' be searched using wildcard character as "Ma*ch" or "Ma?ch" in indexing service?

开发者 https://www.devze.com 2023-04-13 04:27 出处:网络
I want wildcard character to search Match & March at the开发者_Go百科 same time in indexing service. I am trying it with following query:

I want wildcard character to search Match & March at the开发者_Go百科 same time in indexing service. I am trying it with following query:

Select DocTitle,Filename,Size,PATH,URL,Directory 
from Scope() 
WHERE CONTAINS('"Ma*ch"')

Or

Select DocTitle,Filename,Size,PATH,URL,Directory 
from Scope() 
WHERE CONTAINS('"Ma?ch"')

But I am not getting any response as I think it tries to find Ma*ch as the complete word.

When I use * at the end of any prefix then it works fine, but I need it in middle of a word. "Search is being done through documents not from database."


I think correct syntax of contains is

contains (<column Name>,<Search Condition>)

0

精彩评论

暂无评论...
验证码 换一张
取 消