Re: [sqlite] Partial search with fts
On Sat, Nov 29, 2008 at 7:56 PM, Rael Bauer <[EMAIL PROTECTED]> wrote: > Previously someone advised that I use the "*" char to achieve partial search > results with fts. eg ver* will match version. This works ok, but only for > end parts of a word. > > Is there anyway to get partial matches for beginning or middle parts of a > word? > > e.g. *sion - to match version or > *si* to match version Unfortunately, no. Prefix searches are possible because the fts index is stored in sorted order. Doing something like *ed would involve a full scan of the index, and would probably be very slow. -scott ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Partial search with fts
Previously someone advised that I use the "*" char to achieve partial search results with fts. eg ver* will match version. This works ok, but only for end parts of a word. Is there anyway to get partial matches for beginning or middle parts of a word? e.g. *sion - to match version or *si* to match version Thanks Rael ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Partial search with fts
Previously someone advised that I use the "*" char to achieve partial search results with fts. eg ver* will match version. This works ok, but only for end parts of a word. Is there anyway to get partial matches for beginning or middle parts of a word? e.g. *sion - to match version or *si* to match version Thanks Rael ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users