Update the entry in SQL, but do not overwrite ... add text at the beginning

Question

How can I update a table where there is text?

Example: I have the text “say hello” and I want to do it “Peter said hi” - I want to add the word Peter ...

understand?

Many thanks.

Answer 1

Try something like:

UPDATE TABLE_NAME SET FIELD = CONCAT('Peter ',FIELD) WHERE CONDITION;

Answer 2

You tried:

update your_table set field = concat('Peter ', field) where ...