在 mysql 数据库中搜索所有出现的字符串

2021-11-20 00:00:00 mysql

我想弄清楚如何在数据库中定位所有出现的 url.我想搜索所有表格和所有字段.但我不知道从哪里开始，或者是否有可能.

I'm trying to figure out how to locate all occurrences of a url in a database. I want to search all tables and all fields. But I have no idea where to start or if it's even possible.

推荐答案

一个简单的解决方案是这样做:

A simple solution would be doing something like this:

mysqldump -u myuser --no-create-info --extended-insert=FALSE databasename | grep -i "<search string>"

相关文章