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

Reply via email to