I have a database wordpress consisting a lot of tables. I am looking for a certain entry 20.22.31.44. What is the best way to return the table and column if this entry exists?
Asked
Active
Viewed 30 times
0
Somethingwhatever
- 1,390
- 4
- 32
- 58
-
2Does this answer your question? [Search text in fields in every table of a MySQL database](https://stackoverflow.com/questions/639531/search-text-in-fields-in-every-table-of-a-mysql-database) – Guilherme Maia Feb 09 '22 at 20:24
-
@GuilhermeMaia Thank you. I was able to do it using mysql workbench. If you still however add this as an answer, i'll accept it. – Somethingwhatever Feb 09 '22 at 20:48
1 Answers
0
You can dump your database data (SQLDump) into a file and search through it's content.
You may also use a Database Management system (i.e. Workbench, PHPMyAdmin) to perform that global search for you. See related.
Guilherme Maia
- 161
- 1
- 7