Re: [sqlite] FTS3 MATCH syntax

Your suggestion seems to work fairly well. It might have some unexpected results, but I'll definitely give it a try. Thanks! From: Sam Roberts FTS3 tokenizes strings on whitespace (and other chars), so I think the best you can do would be something like given:john given:q.

Re: [sqlite] FTS3 MATCH syntax

On Fri, Sep 24, 2010 at 7:16 PM, GHCS Software wrote: > I'm just started with generating a table using FTS3 and understand > most of the query formats, but am stuck on one minor point of syntax. My > FTS3 query will make reference to a specific table, e.g.: > > MATCH

Re: [sqlite] FTS3 MATCH syntax

I'm not an authority, but I've been using FTS3. FTS3 tokenizes strings on whitespace (and other chars), so I think the best you can do would be something like given:john given:q. It doesn't work really well out of the box for substring matching. On Fri, Sep 24, 2010 at 4:16 PM, GHCS Software

[sqlite] FTS3 MATCH syntax

I'm just started with generating a table using FTS3 and understand most of the query formats, but am stuck on one minor point of syntax. My FTS3 query will make reference to a specific table, e.g.: MATCH 'surname:smith' The problem is that I can't figure out how to specify it if the