update table using replace function

PHOTO EMBED

Tue Mar 15 2022 10:24:08 GMT+0000 (Coordinated Universal Time)

Saved by @Bambibo9799

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