mySQL 替换所有字符串，无论字段名称如何？

Question

我有这个查询，但我想更改找到的每个 field_name 中的字符串，而不是手动更改它。我该怎么做？

update TABLE_NAME 
set FIELD_NAME = replace(FIELD_NAME, ‘find this string’, ‘replace found string with this string’);

Answer 1

然后您必须指定所有字段名。示例

UPDATE tableName
   SET field1 = REPLACE(field1, 'oldstring', 'newstring'),
       field2 = REPLACE(field2, 'oldstring', 'newstring'),
       field3 = REPLACE(field3, 'oldstring', 'newstring'),
       fieldN = REPLACE(fieldN, 'oldstring', 'newstring')