marking all records based on a text file

[Scott Haneda]

I have a large list of email addresses that I have found are undeliverable
to users, I want to mark a field in mysql to 1 where there is this email
address, how can I do this in one go from a \r file.

Something like
update mytable set bad_email = 1 where email_address =
readFile(my_return_sep_file)
--
-------------------------------------------------------------
Scott Haneda Tel: [phone]
http://www.newgeo.com Fax: [phone]
sc***@newgeo.com Novato, CA U.S.A.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw

[JKD]

"Scott Haneda" <li***@newgeo.com> wrote in message
news:bh**********@FreeBSD.csie.NCTU.edu.tw...

I have a large list of email addresses that I have found are undeliverable
to users, I want to mark a field in mysql to 1 where there is this email
address, how can I do this in one go from a \r file.

Something like
update mytable set bad_email = 1 where email_address =
readFile(my_return_sep_file)
--
-------------------------------------------------------------
Scott Haneda Tel: [phone]
http://www.newgeo.com Fax: [phone]
sc***@newgeo.com Novato, CA U.S.A.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw

If your familiar with PHP, you could read the email addresses from your
datafile into an array. From there you could check each record in your
database against this array using the in_array() function.

e.g
While $row = mysql_fetch_array($result){
if (in_array($email)) {
$bad_email = 1;
else{
$bad_email = 0;
}
sql = "update mytable set bad_email = ".$bad_email."
}

SEE: http://us3.php.net/manual/en/function.in-array.php

[JKD]

"Scott Haneda" <li***@newgeo.com> wrote in message
news:bh**********@FreeBSD.csie.NCTU.edu.tw...

I have a large list of email addresses that I have found are undeliverable
to users, I want to mark a field in mysql to 1 where there is this email
address, how can I do this in one go from a \r file.

Something like
update mytable set bad_email = 1 where email_address =
readFile(my_return_sep_file)
--
-------------------------------------------------------------
Scott Haneda Tel: [phone]
http://www.newgeo.com Fax: [phone]
sc***@newgeo.com Novato, CA U.S.A.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw

If your familiar with PHP, you could read the email addresses from your
datafile into an array. From there you could check each record in your
database against this array using the in_array() function.

e.g
While $row = mysql_fetch_array($result){
if (in_array($email)) {
$bad_email = 1;
else{
$bad_email = 0;
}
sql = "update mytable set bad_email = ".$bad_email."
}

SEE: http://us3.php.net/manual/en/function.in-array.php