[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sqlite-users
Subject:    [sqlite] number of term occurances in fts3
From:       "Jos van den Oever" <jvdoever () gmail ! com>
Date:       2008-12-08 16:26:41
Message-ID: c2dbc4260812080826k596ec69eu3d235cf59f7ed2f5 () mail ! gmail ! com
[Download RAW message or body]

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
[prev in list] [next in list] [prev in thread] [next in thread]