Paul Vercellotti wrote:
using FTS, how do you match records that contain certain tokens beginning at
the start of the record
Apparently, this information is not stored in the FTS index.
Search for the tokens, then manually check with LIKE or something like that.
Regards,
Clemens
An: sqlite-users@sqlite.org
Betreff: Re: [sqlite] FTS Find Tokens at Record Start
Paul Vercellotti wrote:
using FTS, how do you match records that contain certain tokens beginning at
the start of the record
Apparently, this information is not stored in the FTS index.
Search for the tokens
Hi there,
I couldn't find this from the documentation: using FTS, how do you match
records that contain certain tokens beginning at the start of the record (or
any token position for that matter).
For example, I want to match records that start with Four score and seven
years ago but not