Поиск столюцов по БД

replace.sql

UPDATE [Таблица] SET [Поле]=REPLACE([Поле],'Строка_1','Строка_2');

//Or full changing

UPDATE `Darabase`.`wp_options` SET `option_value` = 'http://local.com' WHERE `wp_options`.`option_id` = 1;
UPDATE `DataBase`.`Table` SET `Table-column_1` = 'String_1' WHERE `Table`.`Table-column_2` = Value;


UPDATE wp_options
SET option_value = REPLACE(option_value, 'site.ca', 'local.site.ca')
WHERE option_value LIKE '%site.ca%'

search.sql

SELECT column_name 
FROM INFORMATION_SCHEMA.COLUMNS 
WHERE TABLE_NAME IN ( 
    SELECT DISTINCT TABLE_NAME 
    FROM INFORMATION_SCHEMA.TABLES
    WHERE table_schema = 'название базы'