On Thu, Aug 27, 2015 at 1:02 PM, Scott Hess wrote:
> NEAR/0 will probably not care about ordering.
Ah, yes. You are correct. This match expression:
MATCH 'column:word1 NEAR/0 column:word2 NEAR/0 column:word3'
matcher both "word1 word2 word3" and "word3 word2 word1" phrases. So,
it is a no go.
Hi:
My name is Martin, I have been using SQLite for web development for
several years. Can't say enough good things about it.
Recently, I was asked to implement full-text search in an application
with up to 1 million items, each with several columns having AND, OR
and a phrase search
On Thu, Aug 27, 2015 at 11:29 AM, Martin Kucej <
i.librarian.software at gmail.com> wrote:
> On Thu, Aug 27, 2015 at 1:02 PM, Scott Hess wrote:
> > NEAR/0 will probably not care about ordering.
>
> Ah, yes. You are correct. This match expression:
>
> MATCH 'column:word1 NEAR/0 column:word2
On Thu, Aug 27, 2015 at 10:50 AM, Martin Kucej <
i.librarian.software at gmail.com> wrote:
> Recently, I was asked to implement full-text search in an application
> with up to 1 million items, each with several columns having AND, OR
> and a phrase search capabilities. I can only work with FTS4,
4 matches
Mail list logo
