Michael Luich wrote: > try this: Please don't!
> > > UPDATE dbmail_messages SET status = 2 WHERE physmessage_id IN (select id > from dbmail_physmessage, dbmail_mailboxes WHERE > dbmail_physmessage.internal_date < 'NOW - 30 days' AND > dbmail_mailboxes.name="spam";) > > > Michael Luich > Aleksander Kamenik wrote: >> 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, >> > > > > This email and any files transmitted with it are confidential and > intended solely for the individual(s) or entity to whom they are addressed. > > If you have received this email in error please notify the originator of > the message. > > Any views expressed in this message are those of the individual sender. > > This message has been scanned for Content, viruses and spam by > GlobalCerts RiskFilter - E-mail. > www.GlobalCerts.net > > > > This email and any files transmitted with it are confidential and > intended solely for the individual(s) or entity to whom they are addressed. > > If you have received this email in error please notify the originator of > the message. > > Any views expressed in this message are those of the individual sender. > > This message has been scanned for Content, viruses and spam by > GlobalCerts RiskFilter - E-mail. > www.GlobalCerts.net > > _______________________________________________ > DBmail mailing list > [email protected] > https://mailman.fastxs.nl/mailman/listinfo/dbmail > -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
