mysql how to add onto a string if there is already text in it code example

Example: mysql add text to existing field

UPDATE categories SET code = CONCAT(code, '_standard') WHERE id = 1;