Database Reference
In-Depth Information
This is a standard results page. If the results ran in pages, we could navigate through
them, and edit and delete data for the subset we have chosen during the process.
Another feature of phpMyAdmin is that the fields used as the criteria are highlighted
by changing the border color of the columns to better reflect their importance on the
results page.
It isn't necessary to specify that the
isbn
column be displayed even though this is
the column in which we search. We could have selected only the
title
column for
display (see the
Selecting Fields to be Displayed
section) and chosen the
isbn
column
as a criterion.
Searching for empty / non-empty values
In version 3.1.0, two handy operators have been added in the operator's list:
= ''
!= ''
Those are the ones to use when you want to search for an empty (
= ''
) or not empty
(
!= ''
) value in some field. Normally, typing nothing in a field's
Value
means
that this field does not participate in the search process. However, with one of these
operators, this field is included in the generated search query.
Please do not confuse this method with searching for a NULL value, which is quite
different. Indeed, a NULL value (refer to
http://en.wikipedia.org/wiki/
Null_(SQL)
for a more complete explanation) is a special value that conveys that
some information is missing in this column.
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:
Search WWH ::
Custom Search