mercredi 28 janvier 2015

Sqlite FTS4 token prefix for phrase query

I am trying to query a Sqlite database taking into account 2 fields, say title and author, with the following query:


SELECT * FROM books WHERE title MATCH 'Author:<author>* <title>*'


It works when <author> and <title> do not contain spaces (i.e. a single word), but when I try, for example, for author: "mark tw", it will not match any rows because there are 2 words.


So, is it possible to use a prefix for a phrase query composed of multiple words?


Aucun commentaire:

Enregistrer un commentaire