Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-04-11 : 08:45:41
|
| Puneet writes "I want to build a FAQ Section using Full Text Search but my problem is the user may type a sentence to search in databse for his faq but Full text Search only suports Keywords (I think so) as when I use FREETEXT argument it returns all whole lot of resultset. So I am confused what to do in this caseEg : I want to search for a tv company likeWhat is the cost of TV model SRF567 FlatronIf I use Freetext then i will get 10 or more results but i want the most specific result.I have also tried the containtable and FreetextTable Arguments but failed to get the desired result.Thank You,Puneet" |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2002-04-11 : 12:57:15
|
| I presume the way FREETEXT queries in general should work, is to remove the 'noise' words and concentrate the search on the important stuff....so "What is the cost of TV model SRF567 Flatron"would get reduced to"cost TV model SRF567 Flatron"by building a master list of 'noise' words and eliminating them from the user input, the quality of your expected results may improve.if after removing all the 'noise' words, nothing is left to be queried, then maybe the query is too general to generate a useful result set?by 'noise' words...in the sample above I'm including "What, is, the, of"...but there could be much more....HTH |
 |
|
|
puneet_pal
Starting Member
3 Posts |
Posted - 2002-04-12 : 00:42:37
|
quote:
I presume the way FREETEXT queries in general should work, is to remove the 'noise' words and concentrate the search on the important stuff....so "What is the cost of TV model SRF567 Flatron"would get reduced to"cost TV model SRF567 Flatron"by building a master list of 'noise' words and eliminating them from the user input, the quality of your expected results may improve.if after removing all the 'noise' words, nothing is left to be queried, then maybe the query is too general to generate a useful result set?by 'noise' words...in the sample above I'm including "What, is, the, of"...but there could be much more....HTH
I Think that From FREETEXT I GET MULTIPLE QUERIES BUT I WANT ONLY THE MOST MATCHING ONE THEN WHAT TO DO I HAVE TRIED MY BEST BUT FAILED SO PLEASE HELP....THANKS |
|
|
|
|
|
|
|
|
Searching a most matching sentence in Full Text Search while searching for sentences