Geek Answers Handbook

Search all tables using MySQL Workbench

Is it possible to search all tables for a row with MySQL GUI?

Or something like this: mySQL query to search all tables in a database for a row? Only decision?

+5
source share
1 answer

Yes.

From Schema Treeselect the tables and / or schemas that you want to search, right-click and select Search Data Table... from the context menu.

The search has the following options:

Find the fields of the table that: "CONTAINS", "Search using =", "Search using LIKE", "Search using REGEXP". These search options are not case sensitive.

enter image description here

You can get additional information in official documents .

+9

More articles:


All Articles