Issue:Search logic

Priority 2 Created 2023-02-09 Resolved 2023-02-25

Based on how you explain the search logic I'd expect "San Francisco" "SanFrancisco" and "San*Francisco" to all return the same results, but they don't.
You might want to default to less exact matching unless someone specifies "exact match" with quotes i think people would rather more false positives than exactness (for now)

2023-02-09 not mess with FTS3 search logic, but explain better syntax.

2023-02-18 strict logic, degrades to star logic degrades to soundex. To be explained in a blog

2023-02-20 see How the full text search works