On Fri, Sep 24, 2010 at 7:16 PM, GHCS Software <g...@ghcssoftware.com>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? > SELECT * FROM fts3table WHERE surname MATCH "john q"; > > -- > Doug Gordon > *GHCS Software* > http://www.ghcssoftware.com > g...@ghcssoftware.com <mailto:g...@ghcssoftware.com> > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
