Простого пути нет. Самый правильный - UPDATE.
Можно автоматически сгенерировать скрипт для изменения всех колонок текстового типа, примерно так:
use information_schema
select concat_ws(' ', 'update', table_name, 'set', column_name, '= replace(', column_name, ', ''search'', ''replace'' );')
from columns
where table_schema = 'mysql'
and (data_type = 'varchar' or data_type like '%text');
(заменить
table_schema = 'mysql' на нужную вам базу)
+------------------------------------------------------------------------------------------------------------------------+
| concat_ws(' ', 'update', TABLE_NAME, 'set', COLUMN_NAME, '= REPLACE(', COLUMN_NAME, ', ''search'', ''replace'' );') |
+------------------------------------------------------------------------------------------------------------------------+
| update component set component_urn = REPLACE( component_urn , 'search', 'replace' ); |
| update engine_cost set comment = REPLACE( comment , 'search', 'replace' ); |
| update engine_cost set cost_name = REPLACE( cost_name , 'search', 'replace' ); |
| update engine_cost set engine_name = REPLACE( engine_name , 'search', 'replace' ); |
