Database Reference
In-Depth Information
The complete search expression is generated by combining the search
conditions, a logical
AND
, and the other criteria entered in the
query by
example
lines.
We could have a more complex list of search conditions that would be entered in the
same textbox, possibly with brackets and operators such as
AND
or
OR
.
A
Documentation
link points to the MySQL manual, where we can see a huge choice
of available functions. (Each function is applicable to a specific field type.)
Obtaining distinct results
Sometimes, we may want to avoid getting the same results more than once. For
example, if we want to know in which cities we have clients, displaying each city
name once would be enough. Here, we want to know in which languages our topics
are written. In the
Select Fields
dialog, we choose just the
language
field, and we
check
DISTINCT
,
as shown in the following screenshot:
Clicking on
Go
produces the following image:
Search WWH ::
Custom Search