Mysql append data to fields?

Question

I have a table which contains 3 columns, fname Lname and description. I want to take the values of Fname and Lname and append them to description (Move this data to the end of the description field without overwriting the current info in the field). Is this possible with MySQL at all?

are you looking for the CONCAT() function?

Will Palmer
– Will Palmer

2012-10-15 11:39:46 +00:00
Commented Oct 15, 2012 at 11:39 — Will Palmer
– Will Palmer, Commented Oct 15, 2012 at 11:39

Vikram Jain · Accepted Answer · 2012-10-15 11:43:54Z

2

    Please update function as per req...and concatination of string :
Here Concat function is used for concat string..:

update table_name set description = CONCAT(description,' ',fname,' ',Lname);

answered Oct 15, 2012 at 11:43

Vikram Jain

5,6081 gold badge22 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user1746927 Over a year ago

Exactly hat i was looking thanks for pointing out the function i needed.

Tahir Yasin · Accepted Answer · 2012-10-15 11:54:55Z

0

update your_table_name set description = CONCAT(description,' ', fname,' ',Lname);

edited Oct 15, 2012 at 11:54

Tahir Yasin

11.7k6 gold badges46 silver badges61 bronze badges

answered Oct 15, 2012 at 11:42

Matei Suica

8591 gold badge7 silver badges17 bronze badges

1 Comment

Matei Suica Over a year ago

thanks for the review :) i did not put any whitespace since the question did not mention them... but it's ok, i think that's what he meant.

Collectives™ on Stack Overflow

Mysql append data to fields?

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related