Doradus Query Language (DQL) : Contains Clauses : Term Clauses

Term Clauses
A term clause searches a specific field for one or more terms. To designate it as a contains clause, the field name must be followed by a colon. Example:
Name:Smith
This clause searches perspective objects’ Name field for the term Smith (case-insensitive). To specify multiple terms, enclose them in parentheses. Example:
Name:(John Smith)
To match this clause, an object’s Name field must contain both John and Smith, but they can appear in any order and be separated by other terms.
Be sure to enclose multi-term clauses in parentheses! The following query looks like it searches for John and Smith in the Name field:
Name:John Smith // doesn't do what you think!
But, this sequence is actually interpreted as two clauses that are AND-ed together:
Name:John AND *:Smith
Matching objects must have John in the Name field and Smith in any field.
A term can use the wildcards to select terms that match a given pattern. Currently, only the multi-character wildcard * is supported. Example:
Name:J*n
This clause matches any Name that contains a term that begins with ‘j’ and ends with ‘n’.