Michael Monnerie 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 -Jon -- Scanned for viruses and dangerous content by MailScanner _______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
