在PHPMYADMIN里批量查询要替换的内容,适用于数量不是太多的数据直接查询表名+字段名:
SELECT
CONCAT('SELECT "', TABLE_NAME, '" AS table_name, "', COLUMN_NAME, '" AS column_name, COUNT(*) AS occurrences FROM ', TABLE_NAME, ' WHERE ', COLUMN_NAME, ' LIKE ''%你要查询的内容或域名%'';')
FROM
INFORMATION_SCHEMA.COLUMNS
WHERE
TABLE_SCHEMA = '你的数据库名'
AND DATA_TYPE IN ('char', 'varchar', 'text', 'mediumtext', 'longtext');