Re: How to extract string frequencies from an email database?

[Peter Brawley]

The first query is easy, assuming a table email(addr, ...) ...

select addr, count(*) as N
from email
group by addr
order by N desc limit 50;

The second is harder. Simplest solution would be to write a small PHP script that sucks up each email msg into an array of words (eg strings separated by whitespace) and inserts them into a wprdstable. Then you could write a query like the above against the words table.