Database Reference
In-Depth Information
Using either of these methods of doing the query produces the following results:
The
%
character (which matches any number of characters) and the underscore
(
_
) character (which matches a single character) are the wildcard characters
available here.
Case sensitivity
In the previous example, we could have replaced
cinema
with
CINEMA
and
achieved similar results. The reason is that the collation of the
title
column
is
latin1_swedish_ci
. Here,
ci
means that comparisons are done in a
case-insensitive way. Please refer to
http://dev.mysql.com/doc/refman/5.1/
en/case-sensitivity.html
for more details.
Combining criteria
We can use multiple criteria for the same query (for example, to find all the English
topics of more than 300 pages). There are more comparative choices in
Operator
because the
page_count
field is numeric, as shown in the following screenshot:
Search WWH ::
Custom Search