Searching Data - Mastering phpMyAdmin 2.8 for Effective MySQL Management - page 143

In the Find section, we specify how to treat the values entered: we might need to
ind at least one of the words entered, all words (in no particular order), or the exact
phrase (words in the same order, somewhere in a column). Another choice is to use
a regular expression , which is a more complex way of doing pattern matching. We
will keep the default value, at least one of the words .
We can choose the tables to restrict the search or select all tables. As we only have
two (small) tables, we select them both.
As the search will be done on each row of every table selected,
we might hit some time limits if the number of rows or tables
is too big. Thus, this feature can be deactivated by setting
$cfg['UseDbSearch'] to FALSE . (It is set to TRUE
by default).
Clicking Go finds the following for us:
This is an overview of the number of matches and the relevant tables. We might
get some matches in tables in which we are not interested. However, for the matches
that look promising, we can Browse the results page, or we can Delete the
unwanted rows.
Summary
In this chapter we have covered single-table searches with query by example criteria
and additional criteria specification, selecting displayed values, and ordering results.
We also took a look at wildcard searches and full database search.