Using Linux/Unix I'd say:
echo "SELECT concat('DELETE FROM mailtab WHERE
mailaddress=',mailaddress,';') FROM mailtab WHERE <some strange
conditions here>" | mysql <db> | mysql <db>
[EMAIL PROTECTED] wrote:
>I have about 40,000 email addresses in a MySQL database.
>
>I also have a list of 1500 email addresses that need to be removed.
>
>I am searching for a way to delete these 1500 email addresses en masse,
>but I have come up short.
>
>I sure would appreciate a nudge in the right direction from somebody who
>might be in the know.
>
>
>
---------------------------------------------------------------------
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
