UPDATE `表名` SET `列名` = REPLACE(`字段`, ‘现在的内容,’要替换的内容‘); UPDATE `admin` SET `lieming` = REPLACE(`ziduan`, ‘0‘,’9999‘);