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 tab.from the context menu. The following figure shows options available in the
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: [
Max. total matches: [
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.