USE DCP; update base_project_entity SET phase_type='ZZJS' WHERE phase_type IN ('JS','JSTY'); update base_project_entity SET phase_type='QT' WHERE phase_type='GJD'; update base_project_view SET phase_type='ZZJS' WHERE phase_type IN ('JS','JSTY'); update base_project_view SET phase_type='QT' WHERE phase_type='GJD';