How to search a particular word in all databases in my mysql server?

Asked Jun 02 '15 at 09:51

Active Jun 02 '15 at 10:27

Viewed 31 times

I have 780 databases in my mysql server. All the databases contain wp_options table. I need to search a particular word in all the databases inside that wp_options table. Is there any methods to do that? And all my databases start with a prefix common_phrase"_"db_name, for example:

phrase_db1, phrase_db2, phrase_db3 ...

Please suggest me some ideas to do that.

edited Jun 02 '15 at 10:27

Giulio Vian

8,248
2
33
41

asked Jun 02 '15 at 09:51

Abzal

What is the MySQL version? – Repeat Spacer Jun 02 '15 at 10:38
possible duplicate of [Search in all fields from every table of a MySQL database](http://stackoverflow.com/questions/639531/search-in-all-fields-from-every-table-of-a-mysql-database) – Isaac Bennetch Jun 13 '15 at 21:57

How to search a particular word in all databases in my mysql server?

0 Answers0