Hi everyone! I need to run an update query on 400 sets of data. Being given a list of 400 names with 2 email addresses (company and private) each, the task is to update all people who have an old email address (either company or private).
So here are my questions: 1.Is there any way I can load a text file containing the names into my my query? 2. How do I have to build the update statement itself? Can I use some kind of variable? Thanks for your help in advance.... SVen --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php