MySql - 更新字符串部分的方法？

UPDATE table_name SET column_name = CONCAT(column_name, 'new_string') WHERE condition;

UPDATE table_name SET column_name = CONCAT_WS('separator', column_name, 'new_string') WHERE condition;

UPDATE table_name SET column_name = INSERT(column_name, position, length, 'new_string') WHERE condition;

UPDATE table_name SET column_name = REPLACE(column_name, 'old_string', 'new_string') WHERE condition;

UPDATE table_name SET column_name = CONCAT(SUBSTRING(column_name, 1, position - 1), 'new_string', SUBSTRING(column_name, position + length)) WHERE condition;