Re: [sqlite] Prefix searching for fts2.

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,

RE: [sqlite] Prefix searching for fts2.

] -Original Message- From: Scott Hess [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 01, 2007 2:36 PM To: sqlite-users@sqlite.org Subject: [sqlite] Prefix searching for fts2. I just finished ( http://www.sqlite.org/cvstrac/chngview?cn=3893 ) checking in a string of changes to fts2.c to provide

[sqlite] Prefix searching for fts2.

I just finished ( http://www.sqlite.org/cvstrac/chngview?cn=3893 ) checking in a string of changes to fts2.c to provide prefix search. This works like: CREATE VIRTUAL TABLE t USING fts2(c); INSERT INTO t (c) VALUES ('This is a test'); INSERT INTO t (c) VALUES ('That was a test'); INSERT INTO