open_in_new
content_copy
update dept1 set jobrole = replace(jobrole,'Manager','Manager Sales') where department = 'Sales';