I thought of that but I get an error with that query: >> unable to use function snippet in the requested context
Thanks! Matthew On Nov 19, 2010, at 2:08 PM, Petite Abeille wrote: > > On Nov 19, 2010, at 9:46 PM, Matthew Leffler wrote: > >> 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. > > Do it in two steps perhaps? > > select result.extract as extract, > count( * ) as count > from ( > select snippet( search, '', '', '...' ) as extract > from search > where content match 'search term' > ) > as result > > group by result.extract > > order by count desc > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
