Another way to do it, create a temporary table load the content of your text file in
it, and then do your update crossing the two tables.
Marc.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> Subject: marking all records based on a text file
>
>
> 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.
>
&
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
