Check out example codes for "mysql workbench search all tables". It will help you in understanding the concepts better.

Code Example 1

-- In the search bar under "Schemas", type:
*.substring  -- beginning of table name
*.*substring -- anwhere in table name

Learn ReactJs, React Native from akashmittal.com