On Nov 19, 2010, at 10:14 PM, Matthew Leffler wrote:
> I thought of that but I get an error with that query:
>
>>> unable to use function snippet in the requested context
>
Pesky function :P
Then, if everything else fails, you could write it down in a temp table, and
group that.... sigh...
drop table if exists result;
create temp table if not exists result as
select snippet( search, '', '', '...' ) as extract
from search
where content match 'search term';
select result.extract as extract,
count( * ) as count
from 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
