If Column1 has a value of "John" And Column2 has a value of "Doe"
How would I write an UPDATE query to SET Column3 to "John Doe" without selecting the information and reposting it to the data through an UPDATE for each and every record? I've tried: UPDATE $table SET Column3 = Column1 + " " + Column2 UPDATE $table SET Column3 = Column1 & " " & Column2 UPDATE $table SET Column3 = Column1 && " " && Column2 Is there a way to actually do this? Thank you in advance! Andrew --------------------------------------------------------------------- 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