MySQL 用replace函数替换字符串

UPDATE master SET username=REPLACE(username,'admin','zhiqiang');

把master表 username字段的所有admin替换成zhiqiang