mysql批量替換指定字串

將欄位title中的abc替換為123

UPDATE `table1` SET `title` = replace(title, 'abc', '123') WHERE `typeid` =18;