A question: Is is possible to group the data from the snippets() column in a result? The query would look something like the following (which doesn't work):
>> SELECT snippet(search, '', '', '...') as extract, count() as count FROM >> search WHERE content MATCH 'search term' GROUP BY extract ORDER BY count; That would allow ordering by frequency of a given match snippet. Thanks! Matthew Leffler _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users