• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Lesson 7. Searching and Indexing Databases > Refine Searches with Operators

Refine Searches with Operators

An operator is a word or character that you type in the Search box to further define the search. For example, typing AND between two words in the search box means you want to find documents where both words appear. Table 7.2lists the operators and their variations available for you to use.

Table 7.2. Search Operators
Operators and VariationsDescription
And AND &Finds documents that contain all the words or conditions combined with the operator. Example: Man AND Woman
* (asterisk)A wildcard that represents any extension of letters, more than one character per asterisk (doesn't work with dates or numbers). Example: *ow, ho*, *ho*
CONTAINS Contains = (equal sign)Specifies that the field before the operator must contain the text that follows the operator. Example: [title] = Favorite
EXACTCASE ExactcaseFinds documents that contain words where the case matches exactly the example in the Search box. The database's case-sensitive option must be selected. Example: EXACTCASE Notes
Field FIELD [fieldname]Finds documents in which the specified field contains the specified value, using the syntax FIELD fieldname CONTAINS value. Example: FIELD LName CONTAINS Dobbs
NOT Not !Makes query negative. Examples: Man AND NOT Woman, Not [LName] CONTAINS Dobbs, FIELD LName CONTAINS NOT Dobbs
PARAGRAPH ParagraphFinds documents in which words around PARAGRAPH are in the same paragraph and then ranks the documents by how close the words are. The data base's indexing option must be on. Example: desk PARAGRAPH computer
Or OR |ACCRUE ,(comma)Finds documents that contain either of the conditions or words in combination with operator. ACCRUE works a little better when sorting results by relevance. Example: Man OR Mouse
? (question mark)A wildcard that represents any extension of letters—one question mark per character (doesn't work with dates or numbers). Example: ?ow, ho??
““ (quotes)Place quotes around and, or, contains, and so on to have those words treated as words and not as operators.
SENTENCE SentenceFinds documents in which words around SENTENCE are in the same sentence and then ranks the documents by how close the words are. The database's indexing option must be on. Example: desk SENTENCE computer
TERMWEIGHT TermweightGives weight to words in document when documents containing the words are found. Use any value between 0 and 65537, with higher number being most important in ranking. Example: TERMWEIGHT 50 manual OR TERMWEIGHT 75 automatic
= (equal to) < (less than) > (greater than) <= (less than or equal to) >= (greater than or equal to)Numeric operators for use in searching for numbers or dates in number or date fields. Example: FIELD CreateDate > 1/1/1999



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint