Search Entire Database for a single value in all MySQL database tables in one go

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • PriyankaGupta
    Junior Member
    • Mar 2015
    • 1

    Search Entire Database for a single value in all MySQL database tables in one go

    This snippet can search for a value in all MySQL database tables. It can connect to a given MySQL database and retrieves the list of all database tables. This snippet queries each of the tables to search of a given values in all columns of the table. It sets an array variable with the list of tables and columns on which the given value was found.

    PHP Snippet


    Sample: $obg = new searchEntireDB(DBName, userName, pswd, columnName, targetText);<br><br>
    Last edited by PriyankaGupta; 07-25-2015, 01:43 PM.
  • Guest

    #2
    There is a Schemas tab on the side menu bar, click on the Schemas tab, then double click on a database to select the database you want to search. Then go to menu Database - Search Data, and enter the text you are searching for, click on Start Search.

    Comment

    Working...
    😀
    😂
    🥰
    😘
    🤢
    😎
    😞
    😡
    👍
    👎