Database Reference
In-Depth Information
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 the tables in which we may not be interested. However, for the
matches that look promising, we can
Browse
the results page, or we can
Delete
the
unwanted rows.
Restricting search to a column
Sometimes, a particular column name is part of one (or many) tables, and we want to
search only inside this column. For example, suppose that we are looking for "Marc",
but this name could be also part of a book's title. So, we want to restrict the search
to only the "name" column in all the chosen tables. This can be achieved by entering
"name" in the
Inside field
choice.
Summary
In this chapter, we take an overview of single table searches with "query by example
criteria" and additional criteria specification—selecting displayed values and
ordering results. We also look at wildcard searches and full database search. The
next chapter will explain how to perform the operations on tables—for example,
changing a table's attributes, such as its storage engine. The subjects of repairing
and optimizing tables are covered in this chapter as well.
Search WWH ::
Custom Search