Re: [sqlite] Prefix searching for fts2.

2007-05-01 Thread Scott Hess
On 5/1/07, Samuel R. Neff <[EMAIL PROTECTED]> wrote: One suggestion though, instead of (or in addition to) using '*' as the prefix operator perhaps '%' would be more appropriate in order to be closer to the LIKE operator. Hmm. I was mainly just doing what other groups appear to do (Lucene, MYS

RE: [sqlite] Prefix searching for fts2.

2007-05-01 Thread Samuel R. Neff
This is great! The main reason we decided not to use FTS in our project was lack of prefix searching. With this new functionality we'll probably switch to using FTS in a future update. One suggestion though, instead of (or in addition to) using '*' as the prefix operator perhaps '%' would be mor