Right, Puneet, this is what I mean.
I tried the same query with another database with 25.600 rows:
select * from fts_news where description match 'ined'
the query returns 17.080 rows which is wrong because If I do:
select * from fts_news where description like '% ined %'
The query returns 0 rows.
I'm using SqliteSpy with sqlite 3.6.17
Jochi MartÃnez
www.bfreenews.com
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
