Comment from the source: ** TODO: Strangely, it is not possible to associate a column specifier ** with a quoted phrase, only with a single token. Not sure if this was ** an implementation artifact or an intentional decision when fts3 was ** first implemented. Whichever it was, this module duplicates the ** limitation.
So, seems its really not possible Rafael Fabian-40 wrote: > > When I have a basic FTS query that needs to be restricted to a column, I > can write it in two ways: > > 1.) WHERE column MATCH 'apple' > 2.) WHERE table MATCH 'column:apple' > > But when I have a phrase query, I can only write it in one way: > > 1.) WHERE column MATCH '"apple juice"' > > The problem is that when I want to combine the queries (search for 'apple' > in column1 and for "apple juice" in column2) i cannot write the query > like: > > WHERE column1 MATCH 'apple' AND column2 MATCH '"apple juice"' > > Nor can I write it like: > > WHERE table MATCH 'column1:apple column2:"apple juice"' > > So this fairly simple query, seems impossible in FTS? Or does anyone know > how to workaround this (without doing two seperate queries)? > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- View this message in context: http://old.nabble.com/FTS%3A-Phrase-queries-tp32834649p32839669.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users