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' -- Puneet Kishor _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
