What I want to do is not overly complicated (and it works the way I did it) but I want to find out if it can be done easily using MySQL only. Table_a: col1, col2, col3 Table_b: col1, col2, col3 Currently, to replace values in col1 in Table_a with values of col2 in Table_b, I do the following: while read col1 col2; do echo col1 echo col2 # so I can see what's happening mysql -uuser -ppassword database << eof UPDATE Table_a SET col1 = "$col2" WHERE Table_a.col2 = "$col1" eof done < Table_b # data from comma delimited file (exported) I hope that you can see what I am trying to do. I tried to do the same thing prior to importing it into MySQL but gave it up. It was simply too long to go over two WHILE loops with 1600 and 95000 records respectively. So now, I have this kludge where I have glued shell script with MySQL. How could I accomplish the same in MySQL alone? Thanks in advance. -- Bolek, URL: http://www.bolek.com URL: http://slash.bolek.com e-mail: [EMAIL PROTECTED] ICQ: 4086197, Address: 402905326 --------------------------------------------------------------------- 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