O'Reilly logo

Mastering phpMyAdmin 3.1 for Effective MySQL Management by Marc Delisle

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

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

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