{"id":447,"date":"2004-07-23T00:00:00","date_gmt":"2004-07-22T22:00:00","guid":{"rendered":"https:\/\/wwwneu.strehle.de\/tim\/weblog\/archives\/2004\/07\/23\/380\/"},"modified":"2004-07-23T00:00:00","modified_gmt":"2004-07-22T22:00:00","slug":"380","status":"publish","type":"post","link":"https:\/\/www.strehle.de\/tim\/weblog\/archives\/2004\/07\/23\/380\/","title":{"rendered":"Creating Custom Email Queries"},"content":{"rendered":"<p>Robert Bernier at ONLamp.com &#8211; <a href=\"http:\/\/www.onlamp.com\/pub\/a\/onlamp\/2004\/07\/22\/datamining_email.html\" title=\"ONLamp.com: Creating Custom Email Queries\">Creating Custom Email Queries<\/a>:<\/p>\n<p>&#8222;In my last article on <a href=\"http:\/\/www.onlamp.com\/pub\/a\/onlamp\/2004\/04\/08\/datamining_email.html\" title=\"ONLamp.com: Data Mining Email\">data mining email<\/a>, I described how you could upload a Mozilla mailbox into a PostgreSQL database. With the email uploaded, I showed how to search through the email looking for text strings using both the standard SQL and PostgreSQL&#8217;s POSIX regular expressions. As a grand finale, you then saw how you could extract Microsoft Word document attachments and perform text searches on those too.<\/p>\n<p>In the true spirit of hacking, this article will consider the next step of data mining: performing in-depth searches on email by tweaking an existing mail system.&#8220;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Robert Bernier at ONLamp.com &#8211; Creating Custom Email Queries: &#8222;In my last article on data mining email, I described how you could upload a Mozilla mailbox into a PostgreSQL database. With the email uploaded, I showed how to search through the email looking for text strings using both the standard SQL and PostgreSQL&#8217;s POSIX regular [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_share_on_mastodon":"0"},"categories":[1],"tags":[],"class_list":["post-447","post","type-post","status-publish","format-standard","hentry","category-weblog"],"share_on_mastodon":{"url":"","error":""},"_links":{"self":[{"href":"https:\/\/www.strehle.de\/tim\/wp-json\/wp\/v2\/posts\/447","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.strehle.de\/tim\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.strehle.de\/tim\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.strehle.de\/tim\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.strehle.de\/tim\/wp-json\/wp\/v2\/comments?post=447"}],"version-history":[{"count":0,"href":"https:\/\/www.strehle.de\/tim\/wp-json\/wp\/v2\/posts\/447\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.strehle.de\/tim\/wp-json\/wp\/v2\/media?parent=447"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.strehle.de\/tim\/wp-json\/wp\/v2\/categories?post=447"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.strehle.de\/tim\/wp-json\/wp\/v2\/tags?post=447"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}