mysql select add column text code example Example: mysql add text to existing field UPDATE categories SET code = CONCAT(code, '_standard') WHERE id = 1;