Search for exact string in Indexing services

Question

I am working on indexing service of windows server. I need to search exact word on it. Could you please tell me how I can do it.

Eg: I am searching Hello World then how can I get only search for Hello World.

I am using following in my indexing search query.

WHERE CONTAINS(contents,'Hello World').

But its splitting word and searching it.

score 0 · Answer 1 · answered Dec 03 '13 at 12:29

0

WHERE FREETEXT(Contents,'Hello World')

Also check this Article

answered Dec 03 '13 at 12:29

Suraj Singh

Currently I am doing same but its not working. Because of that I am trying with "Content" – Prashant Khadatkar Dec 03 '13 at 12:53
@PrashantKhadatkar It's a workaround but can you try it with `proximity` Searching `contains(' "Hello" near() "World" ').` – Suraj Singh Dec 03 '13 at 13:46
@PrashantKhadatkar IF you need to search a specific word than you can use `=` operator. http://www3.ha.org.hk/qmh/search/ixqlang.htm – Suraj Singh Dec 03 '13 at 13:50

1 Answers1