更新查询区字段名称

update pb_meta_filter_item
set itemTitle = '司库中心', itemTitle_resid = null
where
    filtersId = (select cFilterId from bill_base where cBillNo = 'stct_internalaccountlist' and ytenant_id = 'ri24zv0c')
  and itemTitle = '结算中心';

UPDATE pb_filter_solution_common pfc
    INNER JOIN pb_filter_solution pfs ON pfc.solutionId = pfs.id
    INNER JOIN bill_base bb ON pfs.filtersId = bb.cFilterId
SET pfc.itemTitle = '司库中心',
    pfc.itemTitle_resid = NULL
WHERE bb.cBillNo = 'stct_internalaccountlist'
  AND bb.ytenant_id = 'ri24zv0c'
  AND pfc.itemTitle = '结算中心';