By admin | Fri, 09/02/2011 - 01:15 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'