How to find a term in a mysql database?

1

How can I search all fields of all tables in a particular mysql database? I need to find a word that I have no idea where it is.

In the result you would need the name (s) of the table (s) and the name (s) of the field (s) where the term is.

Any ideas how to do this?

    
asked by anonymous 08.04.2016 / 21:16

1 answer

1

Friend,

I found a person with the same doubt as yours. Take a look at this answer here: link

If you can not, you could simply download your database.sql and search the archive for the term you want. This would be the fastest way, in my opinion

Thiago Luiz is right, I'll paste the answer I found:

In phpMyAdmin to 'Search' feature is available:

  • Select particular database not table.
  • Click 'Search' tab
  • Enter the search term you want
  • Select the tables you want to search in
  • phpMyAdmin screen shot:

    The'Search'featureisalsoavailableinMySQLWorkbench:

  • DatabaseMenu>SearchTableData
  • Selectdatabaseandtablesyouwanttosearch(itwillsearchinselectedtablesonly)
  • InsearchyoucanusewildChars.
  • MySQLWorkbenchscreenshot:

        
    08.04.2016 / 22:26