You might want to check the following: SELECT word FROM fts WHERE fts MATCH '^token'
Beginning with 3.7.9 this should only return records that have 'token' at the beginning of the record. See changelog of 3.7.9: If a search token (on the right-hand side of the MATCH operator) in FTS4 begins with "^" then that token must be the first in its field of the document. ** Potentially Incompatible Change ** -----Ursprüngliche Nachricht----- Von: [email protected] [mailto:[email protected]] Im Auftrag von Clemens Ladisch Gesendet: Freitag, 5. April 2013 15:41 An: [email protected] 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, then manually check with LIKE or something like that. Regards, Clemens _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
