Hi,

So here's the problem.

My forum has like 2-3K spambots that signed up but they're dormant due to all the rules n shit, now i run a wrestling site, 3-5 times a month mass mailing all the members about PPVs and stuff like that.

So, I need to remove the bot emails from my database.

Now the following at the domains that i have in my ban list

Code: 
@meltmail.com
@freeholidayaccommodation.info
@moreprobe.com
@islandaccommodation.info
@seorj.cn
@wpmu.org.cn
@mail.ru
@list.ru
@mailbo********
@bk.ru
@e-email.com
@e-mail.net
@e-mail.com
@e-mail.org
@xmail.com
@xmail.org
@yandex.ru
@email.org
@megapochta.cn
@mail.obmenhelp.ru
@obmenhelp.ru
@3gpfilms.ru
@rambler.ru
@narod.ru
@konversia-aero.ru
@2008-online.info
@hotmail.net
@email.org
@hotmail.org
@tmail.org
shu92
@*.cn
How do i remove them from my database, so i never email anyone with those IDs.

P.S: Mail Queue is about 18K when I send a mass mail.


Thanks i adv.
EvilGenius Reviewed by EvilGenius on . MySQL - Remove Spambot Emails from database Hi, So here's the problem. My forum has like 2-3K spambots that signed up but they're dormant due to all the rules n shit, now i run a wrestling site, 3-5 times a month mass mailing all the members about PPVs and stuff like that. So, I need to remove the bot emails from my database. Now the following at the domains that i have in my ban list Rating: 5