The MySQL client won't be able to do that on its own; you'll need to write a script in your favourite scripting language to do that.
--Michael > -----Original Message----- > From: Scott Haneda [mailto:[EMAIL PROTECTED] > Sent: Tuesday, August 19, 2003 9:00 PM > To: MySql > 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. > > 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/mysql?> [EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]