MySQL Workbench Manual  /  ...  /  Table Data Search Panel

8.1.8 Table Data Search Panel

Find data across a MySQL connection by using the text search feature on any number of tables and schemas.

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

Figure 8.12 Table Search Example: Multiple Tables and Schemas

The figure content is described in the surrounding text.

The search options include:

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

  • Max. matches per table: [100]

  • Max. total matches: [1000]

  • [ ] Search columns of all types: If checked, non-text column type columns are cast to CHAR to perform the matches, otherwise only text types (CHAR, VARCHAR, and TEXT) are searched. This is unchecked by default.

User Comments
Sign Up Login You must be logged in to post a comment.