We are implementing a full-text search in our database and the goal is to be as search engine-like as possible for the user. Unfortunately, it has been difficult finding clearly written information about some of these things involved in the full-text search.
Right now, I am trying to understand the effect of stopwords on the search.
Here is my search phrase: "children washing their hands"
and here is my SQL statement:
The goal of this statement is to return an exact match of the search phrase. (The whole table is supposed to be filtered with the CONTAINSTABLE JOIN with further refinement by the WHERE clause.) Now the phrase exists in the data, but the their stop word prevents any results from returning. I get nothing.
However, if I adjust the table properties to not use a stoplist, I get results.
Does "stop word" mean it stops the query? 'Cuz it sure seems that way! Maybe I am better off not using stoplists at all or I can remove the FORMSOF phrase if there is a stopword. Any thoughts or links?
Right now, I am trying to understand the effect of stopwords on the search.
Here is my search phrase: "children washing their hands"
and here is my SQL statement:
Code:
[blue]SELECT[/blue] TOP 200 j.iJustificationID, j.sJustifications, ct.RANK
[blue]FROM[/blue] JUSTIFICATIONS j
[blue]INNER JOIN[/blue] CONTAINSTABLE (JUSTIFICATIONS, sJustifications, [red]
'FORMSOF(INFLECTIONAL, children)
AND FORMSOF(INFLECTIONAL, washing)
AND FORMSOF(INFLECTIONAL, their)
AND FORMSOF(INFLECTIONAL, hands)'[/red]) AS ct
[blue]ON[/blue] j.iJustificationID = ct.[KEY]
[blue]WHERE[/blue] sJustifications [blue]LIKE[/blue] [red]'%Children washing their hands%'[/red]
The goal of this statement is to return an exact match of the search phrase. (The whole table is supposed to be filtered with the CONTAINSTABLE JOIN with further refinement by the WHERE clause.) Now the phrase exists in the data, but the their stop word prevents any results from returning. I get nothing.
However, if I adjust the table properties to not use a stoplist, I get results.
Does "stop word" mean it stops the query? 'Cuz it sure seems that way! Maybe I am better off not using stoplists at all or I can remove the FORMSOF phrase if there is a stopword. Any thoughts or links?