Search all tables using MySQL Workbench

Question

Can I search all tables for a string with the MySQL GUI?

Or is something like this: mySQL query to search all tables within a database for a string? the only solution?

Answer 1

Yes.

From the Schema Tree, choose the tables and/or schemas you want to search, right click and then select Search Data Table... from the context menu.

The search has some options:

Search for table fields that: "CONTAINS", "Search using =", "Search using LIKE", "Search using REGEXP". These search options are case-insensitive.

You can get more information in the official docs.