Hi all, Can one retrieve the number of times a certain term occurs in an fts table? This can be useful for autocompletion comboboxes. An example query could look like this:
select term, count(term) c from myfts3table where myfts3table match 'h*'; term|c hi|10 hello|20 The snippet function is not exactly what I want. Cheers, Jos _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users