On Sat, Sep 26, 2009 at 5:31 PM, P Kishor <[email protected]> wrote: > On Sat, Sep 26, 2009 at 6:36 PM, marbex <[email protected]> wrote: >> Shopsland gmail wrote: >>> select title from fts_news where fts_news match 'ined' >> >> It looks that you only want to query the title field, so the query should >> be: >> select title from fts_news where title match 'ined' >> or >> select title from fts_news where fts_news match 'title:ined' > > The OP is asking something completely different. Per the OP, there is > no word with 'ined' as any part, yet, an FTS3 query is returning > matches for 'ined'
But the porter stemmer is being used, which means that the match may not be literal. I don't know the specifics of porter, but since "ed" is something likely to be tweaked by stemming, and also "in", it's possible this is hitting an edge case of some sort. Use snippet() to figure out what it is that is being matched. -scott _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
