imvkmark
7/3/2015 - 3:10 AM

sql:replace

sql:replace

update xd_area set areaname = REPLACE(areaname,'办事处','');