数据修改

update table_name set col_name = value where col_name = 11;

字符替换

mysql – Update a column value, replacing part of a string – Stack Overflow

UPDATE tab_name SET col_name = REPLACE(col_name, ‘domain1.example/images/’, ‘domain2.example/otherfolder/’)