Gossamer Forum
Home : Products : Gossamer List : Discussion :

SQL for removing bounced subscribers

Quote Reply
SQL for removing bounced subscribers
The web-based interface isn't really ready to scale. I'm running a company newsletter with 60,000+ subscribers and because the import was not from a validated email database there are many thousands of invalid emails.

The web based interface for removing bounced subscribers is a bit awkward, I have upwards of 300 pages to go through and each time I remove a page of subscribers it sends me back to a list of all subscribers (not just the bounced ones).

Can someone post some SQL that allows mass deletion based on a minimum bounce criteria?

e.g. if bounced (or whatever the column is, I haven't checked) > 2

cdkrg

Able2Know :: Ajooja Directory
Subject Author Views Date
Thread SQL for removing bounced subscribers cdkrg 3853 Oct 31, 2004, 5:49 PM
Post Re: [cdkrg] SQL for removing bounced subscribers
604 3681 Nov 1, 2004, 9:31 AM