Manitou-Mail Wiki

User Tools

Site Tools

Trace:
sql_analysis

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revisionBoth sides next revision
sql_analysis [2011/11/30 12:11] – danielsql_analysis [2012/01/28 02:55] – daniel
Line 59: Line 59:
 select distinct mail_id FROM attachments WHERE content_type='application/pdf' OR content_type like 'image/%'; select distinct mail_id FROM attachments WHERE content_type='application/pdf' OR content_type like 'image/%';
 </code> </code>
 +
 +====== Messages sent or received today  ======
 +<code>
 +select mail_id from mail where msg_date>=date_trunc('day',now());
 +</code>
 +
  
sql_analysis.txt · Last modified: 2019/01/24 17:55 by daniel