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. The following figure shows options available in the Search tab.

Figure 8.12 Table Search Example: Multiple Tables and Schemas

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 check box: 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.