Re: [sqlite] Partial search with fts

2008-12-09 Thread Scott Hess
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

[sqlite] Partial search with fts

2008-12-03 Thread Rael Bauer
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

[sqlite] Partial search with fts

2008-12-01 Thread Rael Bauer
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*