SQL 2000 as Web Search Engine -- sql server data mining

Oren Levy
12/12/2006 5:51:01 PM

Hi All

Iâ€™m trying to write a SQL statement for a web search engine, it should do
the following:
Break down the search string into individual words (for example: â€œ500 MHz
microprocessor USBâ€) and do a Full Text Search on a catalogue for each
individual word and sort it by the rank.
Iâ€™m assuming it should also take into consideration reserved words and signs.

Any ideas where to start or if you can help with the SQL statement itself it
would be very very very helpful.

Also if someone know already of a product or a better way to build a search
engine for a web site, I would love to hear about it.

Thank you very much everyone.

Oren Levy

AlterEgo
1/5/2007 12:45:39 PM

Oren,

Check BOL for Full-Text Catalogs . Most of the work is probably done for
you.

-- Bill

[quoted text, click to view]

sql server data mining : SQL 2000 as Web Search Engine