On Thursday 28 February 2002 3:47 pm, Eric Colley wrote: > I have a MySQL table of basic user information including email address as > one of the fields. The table is about at the 10,000 record mark. I have a > list of bad email addresses that another program found for me (around 2,000 > records). Now how do I take this list of bad email addresses and run a > command or macro of some sort that will delete all the records in the table > with the email field equal to each one of those bad emails? Anyone have a > suggestion for me?
With all due respect, does this have anything to do with spam? Or is the list of email addresses you have here strictly opt-in where the user is required to confirm his address before being added to your list? Sorry for the check but some of us here find spam to be immoral... --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php