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: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED] Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
