Andrew Kuebler wrote:
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
I think you want something like this
update $table set columns3 = concat(column1 , ' ', column2);
--
Sean
---------------------------------------------------------------------
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
