Databases Reference
In-Depth Information
Case sensitivity and search
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
. This collation comes from the collation set, by default, at
database creation unless the server's default collation has been changed (refer to
http://dev.mysql.com/doc/refman/5.1/en/charset-mysql.html
). 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
column is numeric, as shown in the following screenshot:
Search options
The
Options
slider reveals additional panels to further refine the search process.
Selecting the columns to be displayed
In the
Options
slider, a
Select
columns
panel facilitates selection of the columns
to be displayed in the results. All columns are selected by default, but we can
Ctrl
+ Click on other columns to make the necessary selections. Mac users would use
Command
+ Click to select/unselect the columns.
Search WWH ::
Custom Search