Enter the values into the appropriate fields and click the "Find" button to find records the contain the specified patterns.
e.g., If you enter "Dog" in one of the fields, it will match records that contain the phrase "Dog". This includes "madog" "doggy;" etc...
If you enter criteria into more than one field, they will match only those records that match BOTH criteria.
Prepend an equals sign ("=") to any criteria to force exact matching.
e.g., Searching for "=dog" in a field will match records where that field contains "dog" (and not "doggy")
Prepending a less than ("<") or greater than (">") sign to a field will match records where the field has a value LESS THAN (respectively GREATER THAN) the specified value.
e.g., Entering ">2000" in the Year field will match records with published year greater than 2000.
To match records containing values in a range, use "<LowerRange> .. <UpperRange>" where <LowerRange> is the lower bound on matches and <UpperRange> is the upper bound on matches.
e.g., To find records where Year is between 1950 and 2010 enter "1950..2010" in the Year field.
To perform wildcard searches, prefix your query with a tilde ("~"), then include one of the supported wildcard characters in your query.
Supported Wildcards:
- % : Matches any string of length 0 or more characters.
- _ : Matches a single character.
Examples:
- "~J%y" will match only if the field value begins with "J" and ends with "y". E.g. It will match both "January" and "Joy", but not "Joyous" or "AJoy"
- "~B%" will match any rows where the field value begins with "B"
- "~B_b" will match any rows beginning and ending with "b" and is 3 characters long. This would match "bib" and "bob" but not "boob"