The MySQL search capability makes it possible to search for rows in MySQL tables based on one or more criteria.
There are 2 types of search capabilities available – Simple and Advanced – that can be selected from the drop-down, as shown in Figure 53.
In Simple search, select the database and table from the drop-down menus, and then specify one or more criteria using column name, operator, and value triplet, as shown in Figure 53. Then click on the Search button. The Simple search makes it possible to search MySQL repositories without having any knowledge of SQL.
Figure 53: MySQL Search - Simple
Alternatively, users who are familiar with SQL and its variant for MySQL databases can select Advanced search and type and execute a MySQL query directly in the query field, as shown in Figure 54.
Figure 54: MySQL Search - Advanced