Replace a column in MySql

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

This is the best idea to replace items in a particular column.