Re: [sqlite] FTS Find Tokens at Record Start

2013-04-05 Thread Fabian Klebert
2013 15:41 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. Searc

Re: [sqlite] FTS Find Tokens at Record Start

2013-04-05 Thread Clemens Ladisch
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

[sqlite] FTS Find Tokens at Record Start

2013-04-04 Thread Paul Vercellotti
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