The Search pages in the
Table view are intended for single-table lookups. This chapter covers the multi-table Query by example (QBE) feature available in the
Many phpMyAdmin users work in the
Table view, table by table, and thus tend to overlook the multi-table query generator, which is a wonderful feature for fine-tuning queries. The query generator is useful not only in multi-table situations but also in single-table situations. It enables us to specify multiple criteria for a column, a feature that the Search page in the
Table view does not possess.
The examples in this chapter assume that a multi-user installation of the phpMyAdmin configuration storage has been made ...