mysql 搜索标题中字符串,在整个数据库中搜索MySQL中的字符串的方法

I am working on a MySQL database that is huge (about 120 tables). I am trying to make some sense of it and it will help a great deal if I can search all 120 tables + columns for a string I am looking for.

Is that possible to do on a MySQL DB?

解决方案

There is one solution, which might not be what you want. If you dumped the table into a file(mysqldump) with the data, then you would be able to grep any information you wanted out of it.

It would remove the need for time consuming search queries, and is the most efficient way I can think of.

Hope this helps!