Post reply

Full text search not working at certain times

  • August 6, 2008 at 3:32 am

    #195341

    Hi, I have created a fulltext search catalog, and has been executed properly

    I have a column that has the values as below

    on the way

    there

    they

    then

    theatre

    therree

    thesssee

    when i execute the query,

    select emp from emp1 where contains(emp,'"the*"')

    i get the results

    theatre

    therree

    thesssee

    why doesnt on the way, they,then arent shown in the results

    Second Question

    I have the columns

    in a way the

    in case the

    in the pot

    in the queue

    in the well

    in to the day

    When i execute the query

    select emp from emp1 where contains(emp, '(in ~ the)')

    select emp from emp1 where contains(emp, '(in NEAR the)')

    I dont get any results.

    Can anyone let me know the reason why

    Thanks

    Regards

    cmrhema

  • August 6, 2008 at 4:10 am

    #853696

    The reason you don't get the results you're expecting is that Full-text search uses a list of noise words. Noise words are words which normally are not very usefull during searches. All the words you try to find (then, they, in, the) are included in the default noise word list for the english language.

    If you want you can edit the file noiseENG.txt in the FTData folder, but be aware of the consequences. Allowing words like "the" or "in" will result in a lot more hits while the importance of these hits will be very low.

    [font="Verdana"]Markus Bohse[/font]

  • August 6, 2008 at 4:24 am

    #853702

    Thanks Markus

    And if possible can i know the answer to the second one

  • August 6, 2008 at 4:50 am

    #853711

    Hemalatha (8/6/2008)

    Thanks Markus

    And if possible can i know the answer to the second one

    It's the same answer. You search only on words which are in the noise word list.

    [font="Verdana"]Markus Bohse[/font]

  • August 6, 2008 at 4:58 am

    #853716

    Ok Marcus many thanks

    Now suppose i have the words

    where are you going

    are they going

    why are they going

    Is it possible to find out the words which has ARE and GOING

    If yes, may i know how is done please.

    and yes many many thanks for the clarification

  • August 6, 2008 at 5:45 am

    #853730

    As I wrote already before the noise word list is just an text file called noiseENG.txt and it is located in the FTData folder of your SQL Server installation. Have a look into the file to see which words will be ignored during a search.

    You might also want to read here

    and here[/url]

    [font="Verdana"]Markus Bohse[/font]

  • August 6, 2008 at 6:08 am

    #853744

    Thanks for answering all the questions.

    One last question, which one will act faster using like or using full text search

    eg. I want to find employees whose name start from 'a'.

    In such a scenario which is the best choice

    regards

    cmrhema

Viewing 7 posts - 1 through 6 (of 6 total)

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