Open Full Text Search View

FULL TEXT QUERY HELP

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:


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."