Searching Data - Mastering phpMyAdmin 3.1 for Effective MySQL Management - page 147

Searching Data
In this chapter, we present mechanisms that can be used to find the data we are
looking for, instead of just browsing tables page-by-page and sorting them. This
chapter covers single-table searches besides entire database searches. Chapter 13
is a complement to this chapter and presents multi-table query with examples.
Daily usage of phpMyAdmin
For some users, the main use of phpMyAdmin is the Search mode, which is
used for finding and updating data. For this, the phpMyAdmin team has made
it possible to define which subpage is the starting page in Table view, with the
$cfg['DefaultTabTable'] parameter. Setting it to 'tbl_select.php' defines
the default subpage for search.
With this mode, application developers can look for data in ways not expected by the
interface they are building—adjusting and sometimes repairing data.
Single-table searches
This section describes the Search subpage where a single-table search is available.
Entering the search subpage
The Search subpage can be accessed by clicking the Search link in the Table view.
This has been done here for the book table: