下面sql表示根据条件替换表file_upload中字段path中的aaa/替换为bbb/
update file_upload set path= replace(path, 'aaa/', 'bbb/') where id in(select a.id from (select f.id from file_upload f where f.path like'%aaa/%')a );
下面sql表示根据条件替换表file_upload中字段path中的aaa/替换为bbb/
update file_upload set path= replace(path, 'aaa/', 'bbb/') where id in(select a.id from (select f.id from file_upload f where f.path like'%aaa/%')a );