sql语句，数据库用sql语句批量替换特定的字符串

注意REPLACE (name ,’Puma ‘ , ”)   Puma 是区分大小写

UPDATE `oc_product_description` SET name =REPLACE (name ,’Puma ‘ , ”) WHERE `name` LIKE ‘%Puma %
UPDATE `oc_product_description` SET name =REPLACE (name ,’PUMA ‘ , ”) WHERE `name` LIKE ‘%Puma %’

UPDATE `oc_product_description` SET description =REPLACE (description ,’Puma ‘ , ”) WHERE `description` LIKE ‘%Puma %’
UPDATE `oc_product_description` SET description =REPLACE (description ,’PUMA ‘ , ”) WHERE `description` LIKE ‘%Puma %’
UPDATE `oc_product_description` SET description =REPLACE (description ,’puma ‘ , ”) WHERE `description` LIKE ‘%Puma %’

UPDATE `oc_product_description` SET meta_title =REPLACE (meta_title ,’puma ‘ , ”) WHERE `meta_title` LIKE ‘%Puma %’
UPDATE `oc_product_description` SET meta_title =REPLACE (meta_title ,’Puma ‘ , ”) WHERE `meta_title` LIKE ‘%Puma %’
UPDATE `oc_product_description` SET meta_title =REPLACE (meta_title ,’PUMA ‘ , ”) WHERE `meta_title` LIKE ‘%Puma %’

UPDATE `oc_product_description` SET meta_description =REPLACE (meta_description ,’puma ‘ , ”) WHERE `meta_description` LIKE ‘%Puma %’
UPDATE `oc_product_description` SET meta_description =REPLACE (meta_description ,’Puma ‘ , ”) WHERE `meta_description` LIKE ‘%Puma %’
UPDATE `oc_product_description` SET meta_description =REPLACE (meta_description ,’PUMA ‘ , ”) WHERE `meta_description` LIKE ‘%Puma %’

UPDATE `oc_product_description` SET meta_keyword =REPLACE (meta_keyword ,’puma ‘ , ”) WHERE `meta_keyword` LIKE ‘%Puma %’
UPDATE `oc_product_description` SET meta_keyword =REPLACE (meta_keyword ,’Puma ‘ , ”) WHERE `meta_keyword` LIKE ‘%Puma %’
UPDATE `oc_product_description` SET meta_keyword =REPLACE (meta_keyword ,’PUMA ‘ , ”) WHERE `meta_keyword` LIKE ‘%Puma %’

UPDATE `oc_product_description` SET name =REPLACE (name ,’Nike ‘ , ”) WHERE `name` LIKE ‘%nike %’
UPDATE `oc_product_description` SET name =REPLACE (name ,’NIKE ‘ , ”) WHERE `name` LIKE ‘%nike %’

UPDATE `oc_product_description` SET description =REPLACE (description ,’nike ‘ , ”) WHERE `description` LIKE ‘%nike %’
UPDATE `oc_product_description` SET description =REPLACE (description ,’Nike ‘ , ”) WHERE `description` LIKE ‘%nike %’
UPDATE `oc_product_description` SET description =REPLACE (description ,’NIKE ‘ , ”) WHERE `description` LIKE ‘%nike %’

UPDATE `oc_product_description` SET meta_title =REPLACE (meta_title ,’nike ‘ , ”) WHERE `meta_title` LIKE ‘%nike %’
UPDATE `oc_product_description` SET meta_title =REPLACE (meta_title ,’Nike ‘ , ”) WHERE `meta_title` LIKE ‘%nike %’
UPDATE `oc_product_description` SET meta_title =REPLACE (meta_title ,’NIKE ‘ , ”) WHERE `meta_title` LIKE ‘%nike %’

UPDATE `oc_product_description` SET meta_description =REPLACE (meta_description ,’nike ‘ , ”) WHERE `meta_description` LIKE ‘%nike %’
UPDATE `oc_product_description` SET meta_description =REPLACE (meta_description ,’Nike ‘ , ”) WHERE `meta_description` LIKE ‘%nike %’
UPDATE `oc_product_description` SET meta_description =REPLACE (meta_description ,’NIKE ‘ , ”) WHERE `meta_description` LIKE ‘%nike %’

UPDATE `oc_product_description` SET meta_keyword =REPLACE (meta_keyword ,’nike ‘ , ”) WHERE `meta_keyword` LIKE ‘%nike %’
UPDATE `oc_product_description` SET meta_keyword =REPLACE (meta_keyword ,’Nike ‘ , ”) WHERE `meta_keyword` LIKE ‘%nike %’
UPDATE `oc_product_description` SET meta_keyword =REPLACE (meta_keyword ,’NIKE ‘ , ”) WHERE `meta_keyword` LIKE ‘%nike %’

UPDATE `oc_product_description` SET name =REPLACE (name ,’Adidas ‘ , ”) WHERE `name` LIKE ‘%adidas %’
UPDATE `oc_product_description` SET name =REPLACE (name ,’ADIDAS ‘ , ”) WHERE `name` LIKE ‘%adidas %’
UPDATE `oc_product_description` SET name =REPLACE (name ,’adidas ‘ , ”) WHERE `name` LIKE ‘%adidas %’

UPDATE `oc_product_description` SET description =REPLACE (description ,’adidas ‘ , ”) WHERE `description` LIKE ‘%adidas %’
UPDATE `oc_product_description` SET description =REPLACE (description ,’Adidas ‘ , ”) WHERE `description` LIKE ‘%adidas %’
UPDATE `oc_product_description` SET description =REPLACE (description ,’ADIDAS ‘ , ”) WHERE `description` LIKE ‘%adidas %’

UPDATE `oc_product_description` SET meta_title =REPLACE (meta_title ,’adidas ‘ , ”) WHERE `meta_title` LIKE ‘%adidas %’
UPDATE `oc_product_description` SET meta_title =REPLACE (meta_title ,’Adidas ‘ , ”) WHERE `meta_title` LIKE ‘%adidas %’
UPDATE `oc_product_description` SET meta_title =REPLACE (meta_title ,’ADIDAS ‘ , ”) WHERE `meta_title` LIKE ‘%adidas %’

UPDATE `oc_product_description` SET meta_description =REPLACE (meta_description ,’adidas ‘ , ”) WHERE `meta_description` LIKE ‘%adidas %’
UPDATE `oc_product_description` SET meta_description =REPLACE (meta_description ,’Adidas ‘ , ”) WHERE `meta_description` LIKE ‘%adidas %’
UPDATE `oc_product_description` SET meta_description =REPLACE (meta_description ,’ADIDAS ‘ , ”) WHERE `meta_description` LIKE ‘%adidas %’

UPDATE `oc_product_description` SET meta_keyword =REPLACE (meta_keyword ,’adidas ‘ , ”) WHERE `meta_keyword` LIKE ‘%adidas %’
UPDATE `oc_product_description` SET meta_keyword =REPLACE (meta_keyword ,’Adidas ‘ , ”) WHERE `meta_keyword` LIKE ‘%adidas %’
UPDATE `oc_product_description` SET meta_keyword =REPLACE (meta_keyword ,’ADIDAS ‘ , ”) WHERE `meta_keyword` LIKE ‘%adidas %’