替换产品数据库

UPDATE `oc_product_description`
SET `name` = REPLACE(`name`, 'Football', 'Soccer')
WHERE `name` LIKE '%Football%';

UPDATE `oc_product_description`
SET `description` = REPLACE(`description`, 'Football', 'Soccer')
WHERE `description` LIKE '%Football%';

UPDATE `oc_product_description`
SET `meta_title` = REPLACE(`meta_title`, 'Football', 'Soccer')
WHERE `meta_title` LIKE '%Football%';

UPDATE `oc_product_description`
SET `meta_description` = REPLACE(`meta_description`, 'Football', 'Soccer')
WHERE `meta_description` LIKE '%Football%';

UPDATE `oc_product_description`
SET `meta_keyword` = REPLACE(`meta_keyword`, 'Football', 'Soccer')
WHERE `meta_keyword` LIKE '%Football%';

UPDATE `oc_seo_url`
SET `keyword` = REPLACE(`keyword`, 'football', 'soccer')
WHERE `keyword` LIKE '%football%';