[Solved] Mysql - Take data from row and copy it to another row

Sorry if I repost my question in this section, but I'm really in a hurry since I have to finish my work... :frowning:

Dear community,
I have a table with two rows like:

Row1        Row2
=======     =======
7,3         text 1
1,3         text 2
1,2,3       blabla

What i need to do is add/copy all the text from Row1, at the beginning of row2, plus adding some custom text (<br />). Something like:

Row1        Row2
=======     =======
7,3         7,3<br />text 1
1,3         1,3<br />text 2
1,2,3       1,2,3<br />blabla

So, is there a way to do that using MySQL commands?

Thanks
Lucas

SELECT row1, CONCAT( row1, '<br />', row2 ) 
  FROM sometable
1 Like

Thanks, it works perfect!!!! :b: