update 表名 set 列名 = REPLACE (mcategory,"要去掉的字符","") where 列名 like "%要去掉的字符%" 转载于:https://www.cnblogs.com/blog411032/p/5799599.html