By admin | 1:15 AM CST, Fri September 02, 2011 UPDATE files SET filepath = replace(filepath,'default','shksteel.com')批量更新user表mail UPDATE users SET mail=REPLACE(mail,mail,CONCAT('prefix88_', mail)) WHERE mail <> 'zterry@qq.com'