Databases Reference
In-Depth Information
Producing reports with Print view
We see the
Print
view
and
Print
view
(with
full
texts)
links on the results page.
These links produce a more formal report of the results (without the navigation
interface) directly to the printer. In our case, using
Print
view
would produce
the following:
This report contains information about the server, database, time of generation,
version of phpMyAdmin, version of MySQL, and generated SQL query. The other
link,
Print
view
(with
full
texts)
, would print the contents of the
TEXT
columns in
their entirety.
Searching with wildcard characters
Let us assume we are looking for something less precise—all topics with "cinema"
in their title. First, we go back to the search page. For this type of search, we will use
SQL's
LIKE
operator. This operator accepts wildcard characters—the
%
character
(which matches any number of characters) and the underscore (
_
) character (which
matches a single character). Thus we can use
%cinema%
to let phpMyAdmin
find any substring that matches the word "cinema". If we left out both wildcard
characters, we would get exact matches with only that single word.
This substring matching is easier to access, being part of the
Operator
drop-down
list. We only have to enter the word
cinema
and use the operator
LIKE
%...%
to
perform that match. We should avoid using this form of the
LIKE
operator on big
tables (comprising of thousands of rows), as MySQL does not use an index for data
retrieval in this case, leading to wait times that depend on the server hardware and
its current load. This is why this operator is not the default one in the drop-down list,
even though this method of search is commonly used on smaller tables.
Search WWH ::
Custom Search