Opencart批量删除品牌词SQL语句

数据库执行SLQ语句,注意有符号要用反斜杠注释

UPDATE `oc_product_description` SET `name` = REPLACE( name, 'Cobbler\'s Choice ', '' );
UPDATE `oc_product_description` SET `meta_title` = REPLACE( meta_title, 'Cobbler\'s Choice ', '' );
UPDATE `oc_product_description` SET `description` = REPLACE( description, 'Cobbler\'s Choice ', '' );

***执行SQL前要记得备份数据***