Post reply

Full Text Search - Wild card searches

  • December 16, 2014 at 5:28 am

    #313087

    Hi all,

    I was wondering if someone could help me with this, I have a table with a column which has a full text catalog, lets say the data contained is "Golden", when I do a search like so it works;

    WHERE CONTAINS(ColumnA, '"*gold*"')

    However when if I want to do a partial word search, say to find any records with "old" rather than "gold" then it doesn't work.

    i.e

    AND CONTAINS(ColumnA, '"*old*"')

    Is there any way to make it do a partial word search, i.e to return the record because "old" is contained within "Golden"?

    Thanks,

    Nic

    Check out my blog http://www.sqlservercentral.com/articles/Best+Practices/61537/

  • December 16, 2014 at 5:40 am

    #1764908

    * is used in prefix only ie gold* not *gold or *gold*

    One possibility, if possible, is to add additional column(s) with the data reversed and add to FTS and then you could do dlo* to find all words that end in old

    Far away is close at hand in the images of elsewhere.
    Anon.

  • December 16, 2014 at 7:23 am

    #1764927

    Hi,

    Thanks for getting back to me on this.

    So suffix searches are not supported, makes sense as it would have to index just about every possibility and would result in a scan, so in my case I've managed to work around it using an additional LIKE statement (which also does a scan) however as you pointed out the reverse string would do the job as well.

    Thanks,

    Nic

    Check out my blog http://www.sqlservercentral.com/articles/Best+Practices/61537/

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

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