Hi,
This is actually more of a SQL question than dbmail. I'm not really
familiar with SQL, so I'm asking for help here, as this might interest
some other dbmail admins.
In my setup every user has a mailbox named "spam" which contains as
you've guessed it -- spam.
Some users don't clean up their spam boxes at all, some don't do it
frequently.
So I need to construct some wild JOIN which would do something like this:
UPDATE dbmail_messages SET status="2"
WHERE dbmail_physmessage.internal_date < 'NOW - 30 days'
AND dbmail_mailboxes.name="spam"
Please help with creating this query.
Using mysql 5.0.x.
Kind regards,
--
Aleksander Kamenik
system administrator
+372 6659 649
[EMAIL PROTECTED]
Krediidiinfo AS
http://www.krediidiinfo.ee/
_______________________________________________
DBmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
