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

Reply via email to