CODEWITHSUNDEEP
mysqlmysql-workbench
Chris McKinnel
Chris McKinnel

Reputation: 15082

Search all tables using MySQL Workbench

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?

Upvotes: 16

Views: 24284

Answers (1)

hlscalon
hlscalon

Reputation: 7552

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.

enter image description here

You can get more information in the official docs.

Upvotes: 25

Related Questions