批量修改数据库的字段

SELECT `客户搜索词`,`客户搜索词还原`,`单词`  FROM  `词频_app` WHERE `客户搜索词` LIKE '%patterned%'
SELECT COUNT(1) FROM   `词频_app` WHERE `客户搜索词` LIKE '%patterned%'
UPDATE `词频_app` SET `客户搜索词还原`=REPLACE(`客户搜索词还原`,'pattern','patterned') WHERE `客户搜索词` LIKE '%patterned%';
UPDATE `词频_app` SET `单词`=REPLACE(`单词`,'pattern','patterned') WHERE `客户搜索词` LIKE '%patterned%';


SELECT `客户搜索词`,`客户搜索词还原`  FROM  `搜索词_app` WHERE `客户搜索词` LIKE '%patterned%'
SELECT COUNT(1) FROM   `搜索词_app` WHERE `客户搜索词` LIKE '%patterned%'
UPDATE `搜索词_app` SET `客户搜索词还原`=REPLACE(`客户搜索词还原`,'pattern','patterned') WHERE `客户搜索词` LIKE '%patterned%';