批量修改title

update xxx c set title=CONCAT((select catalog_name from yyy where entity_id=c.main_catalog_id) ,“源码”) where sub_category in(95,96,97,101)

xxx,yyy为表名