Update a record in SQL but not overwrite....add text at the start

Question

Please how I can update table where is some text?

Example: I have text "said hello" and I want to make this "Peter said hello" - I want to add word Peter...

understand?

Thanks very much.

Answer 1

Try something like :

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