Your best solution...

Actrol.com.au - Search Help

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