Post reply

SQL full text web search

  • December 13, 2006 at 11:04 am

    #171573

    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.

    P.S

    This site rules.

    Oren Levy

  • December 13, 2006 at 2:04 pm

    #677905

    Create Full Text Indexes on your catalog and use the FREETEXT predicate in your select statements. You can also look into FREETEXTTABLE for returning resultsets by rank.

    Ronald San Juan | SQL DBA
    ID 710124 ~ Code "Northwind"

  • December 13, 2006 at 2:20 pm

    #677915

    Thanks a million Ronald.
     
    Works like a charm
     
    Oren

  • December 14, 2006 at 8:53 am

    #678110

    You might check out stuff from Scott Cate here:

    http://scottcate.mykb.com/

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply