Append and prepend text to a column

Question

I need to append and prepend each value in a column called description with <p></p>

So I need to append each value with <p> and append with </p>

So the following test will become <p>test</p>.

Could anyone suggest a query that will handle this?

Answer 1

UPDATE mytable SET description = CONCAT("<p>", description, "</p>")

Answer 2

You can try like this:

update mytable
set col = '<p>' + col + '</p>';

or else you can use the CONCAT function like

update mytable
set col = CONCAT('<p>', col, '</p>')