Grapes on the vine
winefiles.org uses MySQL searching, and its boolean operators. These are ways to expand or refine your search.

Note that this help only applies to the basic search function. The Full-featured Search does not provide boolean searching.

  1. The Default search is an implied 'or'. If you put 'port wine' in the box, you will get all the records that contain either the word 'port' or the word 'wine.' As this is a database about wine, that is many thousands of records.
  2. To get only those records that contain both the words 'port' and 'wine' you need to put a plus sign '+' in front of each word, like this: '+port +wine' and this will bring back records that contain both the words, 'port' and 'wine.'
  3. To get a phrase or group of words in exact order, put the words between double quotation marks, like "port wine" or "cabernet sauvignon". This will retrieve those records that contain what is between the double quotation marks literally exactly as it was typed.
  4. To exclude a word, use the minus sign '-' If you wanted all the records that contain the word port, but not the word wine, key in this: '+port -wine'
  5. To truncate a word, use the asterisk '*'

Examples:

port wine
Find articles that contain at least one of the two words.
+port +wine
Find articles that contain both words.
+port wine
Find articles that contain the word “port”, but rank articles higher if they also contain “wine”.
+pinot -chardonnay
Find articles that contain the word “pinot” but not “chardonnay”.
ferment*
Find articles that contain words such as “ferment”, “ferments”, “fermenting”, or “fermentation”.
"malolactic fermentation"
Find articles that contain the exact phrase “malolactic fermentation” (for example, articles that contain “malolactic fermentation” but not “malolactic special fermentation”). Note that the double-quote (") characters that surround the phrase are operator characters that limit the phrase to exactly what was typed between the double quotes.

This Project is supported by the U.S. Institute of Museum and Library Services under the provisions of the
Library Services and Technology Act, administered in California by the State Librarian, and by several Wine Industry Groups.

This document is created by software at the moment of request.
Questions or comments about this service may be directed to winelibrary@sonoma.lib.ca.us.