merging two rows

[wxdqz]

I got two columns:

first_row (blob)
second_row (varchar)

both contain data, where second_row could be empty in several rows.

I would like to merge the data of second_row into first_row by adding it to the end of the data followed by a "\n".

e.g.

first_row: "some text"
second_row: "another text"

--> first_row: "some text\nanother text"

I thought about LAST_INSERT_ID(), but I guess this is only good for integers...?
UPDATE mytable SET first_row = LAST_INSERT_ID(first_row+"\n"+second_row)


thanks a lot
philip