将字段title中的abc替换为123 UPDATE `table1` SET `title` = replace(title, 'abc', '123') WHERE `typeid` =18; 转载于:https://www.cnblogs.com/xcxc/p/3359592.html