MySql批量查询修改某列数据的值

update bd_region a inner join (SELECT REGION_ID as id,concat("野猫井",substr(REGION_NAME,instr('部',REGION_NAME)+1,LENGTH(REGION_NAME))) as yy FROM bd_region WHERE ORGAN_ID="2019073") as b on a.REGION_ID =b.id set a.REGION_NAME = b.yy;