Re: [sqlite] Exact Match Syntax with FTS3?

2009-06-29 Thread Raeldor
Hi, Thank you for your reply. By exact, I mean "this is a test case" should only be returned as a match if the search term is "this is a test case" and not "test case" or "this is a" or anything such like. I added a simple AND clause as per your suggestion and it seems to work great. It's

Re: [sqlite] Exact Match Syntax with FTS3?

2009-06-29 Thread Scott Hess
On Mon, Jun 29, 2009 at 8:52 AM, Raeldor wrote: > Does anyone know if there is a syntax in FTS3 to perform an exact match?  I > couldn't see any examples in the sqlite documentation for this, but I think > there are some operators (*) that are not covered in that

[sqlite] Exact Match Syntax with FTS3?

2009-06-29 Thread Raeldor
Hi All, Does anyone know if there is a syntax in FTS3 to perform an exact match? I couldn't see any examples in the sqlite documentation for this, but I think there are some operators (*) that are not covered in that documentation. Thanks Rael -- View this message in context: