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.
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 ...