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<vieuxt...@gmail.com> FTS3 tokenizes strings on whitespace (and other chars), so I think the best you can do would be something like given:john given:q. On Fri, Sep 24, 2010 at 4: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? > > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
