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-01-01 : 23:20:27
|
| Farshad Hemmati writes "I have a SQL table with the following attributes:----------------------------Title [varchar 1000]Description [varchar 1000]URL [varchar 1000]----------------------------Now, if someone searches for something like "computer", I want to search the database of over 20 million entries, and return the results by relevancy.If the word is in the Title, i want a higher ranking, than if it was in the description.Also, if the word is in BOTH the title and the description, then the ranking is even higher.Also, if the word appears more than once in one of the items, (for examples, "the -computer- of all -computer- places") then it should concider it more relevant.I am running Microsoft SQL Server 2000, on MS Windows 2000 Adv Server.How can I do this?Best Regards,Farshad Hemmati" |
|
|
|
|
|
Creating a Search Engine