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. 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 |