Python Forum
FTS5 again - Printable Version

+- Python Forum (https://python-forum.io)
+-- Forum: Forum & Off Topic (https://python-forum.io/forum-23.html)
+--- Forum: Bar (https://python-forum.io/forum-27.html)
+--- Thread: FTS5 again (/thread-40063.html)



FTS5 again - DPaul - May-26-2023

FTS5 again, and not for the last time. Sad
I have a hard time comparing the various docs we have uncovered,
and making sense of what they try to explain.
For starters, the MATCH operator.
They say:
MATCH "one two three" -> will match all of those words against the document, with an AND logic. Yes, this seems to work.
Then:
MATCH "one two thr"* -> will match the first 2, and anything starting with "thr".
According to the many tests I did, ... the phrase:
MATCH "thr" ->without the "*" will also match anything starting with "thr".

So my conclusion would be that the "*" wildcard does not do anything useful ?
I you can think of a clever phrase that would flush out the difference, tell me.
In practice, users search for names in payer cards. If they don't have to bother with the "*", good!
thx,
Paul