On 14 Jun 2012, at 6:12pm, Philip Bennefall <[email protected]> wrote:
> The trouble I have is that in my query, all the keywords don't necessarily > have to be present in order for a successful match to be made. SqLite's fts > only seems to match if all the keywords are present, which I don't require. You will have to do some of this in your own programming. In fact you may end up doing all of it in your own programming and using the FTS feature only to match single words and single word-fragments. The usual way to do this is to define a 'distance' metric for comparing two strings and finding how far apart they are. A score of 0 means they match exactly. Numbers bigger than a certain amount don't matter: anything bigger than, say, 100 means they're not at all alike. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
