mysql update某个字段替换成某个值

UPDATE  xc_admin_vehicle SET brandid= REPLACE(brandid, 19, 54)

UPDATE  xc_admin_models SET bid= REPLACE(bid, 19, 54)