MACROMEDIA ColdFusion MX, Develop Manual, Page: 545 / 860

Composing search expressions 545
Relational operators
Relational operators search document fields (such as AUTHOR) that you defined in the
collection. Documents containing specified field values are returned. Documents retrieved using
relational operators are not ranked by relevance, and you cannot use the MANY modifier with
relational operators.
You use the following operators for numeric and date comparisons:
For example, to search for documents that contain values for 1999 through 2002, you perform
either of the following searches:
•
A simple search for 1999,2000,2001,2002
•
An explicit search using the = operator: >=1999,<=2002
If a document field named PAGES is defined, you can search for documents that are 5 pages or
less by entering
PAGES < 5 in your search. Similarly, if a document field named DATE is defined,
you can search for documents dated prior to and including December 31, 1999 by entering
DATE <= 12-31-99 in your search.
ALL Selects documents that contain all of the search elements that you specify. A score
of 1.00 is assigned to each retrieved document. ALL and AND retrieve the same
results, but queries using ALL are always assigned a score of 1.00.
ANY Selects documents that contain at least one of the search elements that you specify.
A score of 1.00 is assigned to each retrieved document. ANY and OR retrieve the
same results, but queries using ANY are always assigned a score of 1.00.
Operator Description
= Equal
!= Not equal
> Greater than
>= Greater than or equal to
< Less than
<= Less than or equal to
Operator Description