eden van onenigheid.
>
> All email sent by me is careware. This means that it can only be reread and
> kept if you are good for all the life here on earth and beyond. If you don't
> agree to these terms, you should return this email in no more than 24 hours
> stating the reason o
[EMAIL PROTECTED] wrote:
>Not surprisingly, I'm still confused. Could you hold my hand?
>
>Here's what I've got --
>
>This is my table --
>
>CREATE TABLE churchmail (
> email varchar(30) NOT NULL
>);
>
>It has one field containing 40,000 email addresses.
>
>I have a text file -- remove.txt, w
e here on earth and beyond. If you don't
agree to these terms, you should return this email in no more than 24 hours
stating the reason of disagreement.
-Oorspronkelijk bericht-
Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Verzonden: donderdag 11 juli 2002 03:28
Aan: [EMAIL PROTECTED]
CC:
Not surprisingly, I'm still confused. Could you hold my hand?
Here's what I've got --
This is my table --
CREATE TABLE churchmail (
email varchar(30) NOT NULL
);
It has one field containing 40,000 email addresses.
I have a text file -- remove.txt, which contains 1,500 email addresses
which
personally, i'd just use perl:
my @deademails = ("long", "list", "of", "emails");
take the output of:
select email from table
drop that into another array (@allemails)
then do a for loop through all the emails
checking to see if each line of @allemails matches any line of @deademails
if i
Using Linux/Unix I'd say:
echo "SELECT concat('DELETE FROM mailtab WHERE
mailaddress=',mailaddress,';') FROM mailtab WHERE " | mysql | mysql
[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 remove
