mardi 5 avril 2016

How to query in sqlite fts3 table using "-*"?

I have a fts3 table named tab and a lot of entries in it. When I run this query:

SELECT * FROM tab WHERE key MATCH 'an*';

I get the results like this:

an
anul
an-

But when I run this query:

SELECT * FROM tab WHERE key MATCH 'an-*';

it still results the "an" entry. The result would be like:

an
an-

How can I write my query so the result woudn't be "an", but only those entries that actually contains the character "-"?

Aucun commentaire:

Enregistrer un commentaire