Post reply

Full-text searching: problem with search results

  • June 13, 2005 at 9:09 am

    #61871

    Hi everyone,

    I am having a little problem with the search results when I am searching for the following:

    SELECT Title

    FROM Document

    WHERE CONTAINS(Title, '"MAPP 4"' )

    For some reason 4 is being completely ignored and the query returns all titles that contain MAPP. I want it to return only the titles where 4 directly follows the word MAPP.

    When I search for this

    SELECT Title

    FROM Document

    WHERE CONTAINS(Title, '"MAPP 40"' )

    it is producing the results that I want.

    Could somebody explain to me why it is ignoring the number?

    How do I perform exact searches?

    Any help would be appreciated!!!

  • June 14, 2005 at 12:34 am

    #565175

    Sure... Single digit numbers (0 - 9) are included by default in all of the language specific noise word files. What you need to do is to remove these single digits from the noise word file that is assocated with the FT-enabled column's "Language for Word Breaker". Assuming that you are using US English, you will need to open noise.enu with notepad.exe in the folder \FTDATA\SQLServer\Config where you have SQL Server installed. You will need to stop the MSSearch service before you can save your changes. Once saved, re-start the MSSearch service and run a Full Population and the retest your first query.

    Thanks,

    John

    SQL Full Text Search Blog

    http://spaces.msn.com/members/jtkane/


    John T. Kane

  • June 14, 2005 at 10:40 am

    #565406

    John,

    Thanks a lot for the reply. I'll give it a shot!

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

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