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