update dbmail_messages set status=2
where status>2 and mailbox_idnr in
(select mailbox_idnr from dbmail_mailboxes b
join dbmail_users u on b.owner_idnr=u.user_idnr
where u.userid='testuser1');
Jorge Bastos wrote:
> Guys, sorry,
> I know this has been asked several times but tell me.
> I have deleted and purged messages in imap, and i want to restore those
> purged messages to deleted only, and a certein user only.
> Who can give me a hand on this?
>
> Jorge
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> DBmail mailing list
> DBmail@dbmail.org
> 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
