O'Reilly logo

MySQL Management and Administration with Navicat by Gokhan Ozar

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Revealing a hidden search feature of Navicat

You can use Navicat to locate one or more database table records matching a certain criteria. After you select a database or schema from the left-hand side pane of Navicat's main window and right-click on it, you will see the Find in database... command among the items of the opening pop-up menu. Issuing this command will reveal a pop-up window that will let you enter a search string and matching criteria (such as Exact or Contains, or even evaluate a Regular Expression).

For example, select our_first_db that we created in Chapter 2, Working with Databases, and right-click on it and choose Find in database.... Then, enter manager in the search box, leave the matching criterion as Contains, and click ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required