 Monkey Server - Search Help
|
- Search Terms
There are 3 types of search terms:
- Word Partial Match – This is the default type of search term. If you simply enter a word (or string of characters) then it is considered a match if the word exists anywhere within the field that you are searching.
- Phrase Partial Match – If you want to search the field for a phrase then enclose the phrase in single quotes. If the phrase is found anywhere within the field it is considered a match. If your search term contains a single quote then you must replace the one single quote with two single quotes.
- Phrase/Word Complete Match – If you only want to return records that are an exact match then enclose them in double quotes. If your search term contains a double quote then you must replace the one double quote with two double quotes.
- Wildcards
- "%" – Enter this anywhere in your search term and it will match any ZERO OR MORE characters.
- "_" (underscore) – Enter this anywhere in your search term and it will match any ONE character
- Operators
- AND – Use this to join several search terms together. This operator is entirely optional as a space between terms is an implied AND operator.
- OR – Use this between search terms when you want to include/exclude records in which either search term is a match.
- Grouping
Grouping can be done use Parenthesis. This is most often helpful for complex queries that utilize the OR operator. Groups can be nested if necessary.
- Exclusions
If you precede a search term with a minus sign (-) it will exclude any matches from the search results.
- Examples
This will display all songs in which the Artist name begins with the letter "A"
This will display all songs that include both "elvis" and "costello" in the artist field and that don’t include "country" or "classical" in the genre field.
This will include all songs in which the artist field exactly matches "Frank Zappa" and the genre field includes either "funk" or "fusion".
This will include all songs in which the artist field exactly matches "Cheap Trick" or the artist field contains "xtc" and the genre includes "pop and the genre also contains "new wave" or "punk" and the genre doesn’t include "electro".
- Limitations
There currently is an implied “AND” between fields so you can’t search for songs that have an artist field that contains "XTC" OR a song field that contains "Sunny" within the same search.
|
|
|