Databases Reference
In-Depth Information
Clicking on
Go
produces the following:
Using
DISTINCT,
we only see the two page counts '
200
' and
'
600
' once. Without this option, the row containing '
200
' would
have appeared twice.
Complete Database Search
In the previous examples, searching was limited to one table. This assumes
knowledge of the exact table (and columns) where the necessary information might
be stored.
When the data is hidden somewhere in the database or when the same data can be in
various columns (for example, a
title
column or a
description
column), it is easier to
use the database-search method.
We enter the
Search
page in the Database view for the
dbbook
database:
In the
Word(s) or value(s)
section, we enter what we want to find. The
%
wildcard
character can prove useful here. We enter
souvenirs
.
Search WWH ::
Custom Search