UPDATE $table SET Column3 = CONCAT(Column1," ",Column2); http://www.mysql.com/doc/en/String_functions.html#IDX1162
-----Original Message----- From: Andrew Kuebler [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 11, 2002 12:45 PM To: [EMAIL PROTECTED] Subject: UPDATE 1 Column from merging 2 or more others 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 --------------------------------------------------------------------- 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
