On Donnerstag 23 Juli 2009 Jonathan Feally wrote: > > select * from dbmail_messages where physmessage_id IN (select > > physmessage_id from dbmail_subjectfield where subjectfield like > > 'Annoying%DELETE THIS MESSAGE%'); > > > > Instead of "select *" simply write "DELETE" and those messages are > > gone. > > > > mfg zmi > > > > I'm glad you responded first. I forgot about those views and was > going to give a very nasty query back to do it. That should work in > both 2.2.x and 2.3.x
:-) Please anybody doing above query be reminded to change the Subject you are searching for - otherwise you delete all mails belonging to this thread ;-) My advise is to make the "select" first to see if it works, and only afterwards change it to "delete". mfg zmi -- // Michael Monnerie, Ing.BSc ----- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: "curl -s http://zmi.at/zmi.asc | gpg --import" // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4
signature.asc
Description: This is a digitally signed message part.
_______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
