Searching Data - Mastering phpMyAdmin 3.4 for Effective MySQL Management - page 157

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. In Search
mode, application developers can look for data in ways not expected by the interface
they are building—adjusting and sometimes repairing data. This chapter covers
single-table searches and entire database searches. Chapter 12 is a complement to this
chapter and presents examples of searches involving multiple tables at once.
Single-table searches
This section describes the Search page where a single-table search is available.
Searching in just one table is effective only in the situation where a single table
regroups all the data on which we want to search. If the data is scattered in many
tables, a database search should be launched instead, and this is covered later in
the chapter.
Entering the search page
The Search page can be accessed by clicking on the Search link in the Table view.
This has been done here for the book table: