Replace a column values in MySql

UPDATE mba_manpower_master SET contractor = REPLACE(contractor, 'D_S_Engg', 'D S Engg') ;