How to extract string frequencies from an email database?
Posted by:
Mike Levin
Date: October 20, 2017 05:16PM
I am a total newbie to MySQL; in fact my only contact with MySQL is that it's used as a back end to MailStewardPro - a piece of Apple software that stores emails in a database. What I'd like to do (which this software doesn't do) is issue a query of some sort that would do the following:
1) give me the top 50 most frequent senders (strings in the From field)
and/or
2) give me the top 50 most frequent words in the bodies of the emails
is there an easy way to issue queries about such data analytic properties?
Subject
Written By
Posted
How to extract string frequencies from an email database?
October 20, 2017 05:16PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.