Full Text Query Help


Typing any of theseFinds
NOT not !documents that do not contain the condition or word following NOT
AND and &documents that contain both the conditions or words separated by AND
OR or |documents that contain either of the conditions or words separated by OR
ACCRUE accrue , (comma)the same documents as OR, but increases the relevance ranking of a document when the document contains more than one matching conditon or word
@documents which contain both of the words that are separated by @, as long as the words are next to each other in the documents. (Do not place spaces between @ and either word.)

Examples
Typing this textFinds documents that contain
cat & dog & fishall three of these words
cat | dog | fishat least one of these words
cat, dog, fishat least one of these words. Notes gives higher relevance to documents that contain two or three of these words
dog@fishdog and fish next to each other
(dog AND cat) OR fishdog and cat; fish
dog AND (cat OR fish)dog and cat; dog and fish
dog AND NOT (cat OR fish)dog, as long as they don't also contain cat or fish

Changing the relevance ranking of certain search words

If your database has a full text index, you can use the Termweight operator to change the relevance ranking of search words, thus increasing or decreasing their importance in the search. Documents in which the search text is most important appear at the top of the list of search results (when you sort the results by relevance).

To use the Termweight operator, type your search text as follows:

  • termweight 80 word1 or termweight 20 word2

    where the numbers following "termweight" can be any integer from 0 - 100.


    Examples of using the Termweight operator
    The table below shows some examples of using the Termweight operator to change the relevance ranking of search words.


Search textResults of search
termweight 70 video or termweight 30 audioFinds documents that contain "video" or "audio" or both. Gives a much higher relevance to "video" than to "audio."
termweight 25 photo or termweight 75 audio or termweight 50 videoFinds documents that contain any of the words "photo," "audio," or "video." Gives the highest relevance to "audio," the next highest relevance to "video," and the least relevance to "photo."