Lubos Staracek wrote: > From what I've seen here: > http://www.mail-archive.com/sqlite-users@sqlite.org/msg57661.html I assume > that snippet would return one text fragment for each column that have > matched searched phrase.
Snippet is called once for each matching record. So it returns at most one snippet per record. > Problem is, I would need to get text fragment for each occurence of a > searched phrase, even when that phrase occurs in one column of one row > multiple times. Is it possible to achive such a thing with snippet? If two occurences are near each other, they will both be highlighted in the returned text fragment. But otherwise, you have to retrieve the entire text of the record and extract the matches yourself. Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users