根据条件替换sql数据表某一列的值 UPDATE WM_Company SET WM_AreaID = REPLACE(WM_AreaID, ’17′, ’19′), WM_AreaB = REPLACE(WM_AreaB, ’1′, ’0′) WHERE (WM_Address LIKE ‘%罗庄%’) Facebook Twitter Google Bookmarks del.icio.us StumbleUpon Digg Reddit Posterous