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 <[email protected]> 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 'surname:smith' > > The problem is that I can't figure out how to specify it if the string > to be searched for has a space in it. I've tried several varieties of > quotes without any success, e.g.: > > MATCH '"given:john q"' > MATCH 'given:"john q"' > > and so on. Is there a way to get this to work? > > -- > Doug Gordon > *GHCS Software* > http://www.ghcssoftware.com > [email protected] <mailto:[email protected]> > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
