You need to use the CONCAT() function in MySQL for string concatenation:
CONCAT()
UPDATE categories SET code = CONCAT(code, '_standard') WHERE id = 1;
Update image field to add full URL, ignoring null fields:
UPDATE test SET image = CONCAT('https://my-site.com/images/',image) WHERE image IS NOT NULL;