Searching tips
This tool allows for simple and more complex searches to be performed. However, please take care where using the "or" or "OR" operators, as these behave in different ways and can give quite different results depending on their usage!
Contains all the words(s) or "phrase"
finds all records that contain all entered words or "phrases", anywhere in the selected field, and in any order. When specifying more than one word or "phrase" then the default search will place an "and" between each separate word or "phrase", so you don't need to worry about entering "and" yourself. Placing an "or" between words or "phrases" will alter the default behaviour and find records where the selected field contains either word or "phrase".
Begins with the words(s) or "phrase"
this is more specific than the above. Only finds records that start with the entered word of "phrase". Entering more than one word is treated as a "phrase."
Ends with the words(s) or "phrase"
as above. Only finds records that end with the entered word of "phrase". Entering more than one word is treated as a "phrase."
Does not contain the words(s) or "phrase"
similar to the contains search, but obviously looking for records where there isn't a match. When specifying more than on word or "phrase" then the default search will place an "and" between each separate word or "phrase". Placing an "or" between words or "phrases" will alter the default behaviour and find records where the selected field does not contains both words or "phrases".
Exactly matches the words(s) or "phrase"
as it says on the tin; will only find records where the selected field matches exactly with whay you enter. The only exception here is that apostrophes are ignored.
Is Between/Is Not Between two values
specifically used when searching dates or years.
Is Empty/Has no value
finds records where the selected field is unused, or NULL.
"or" searches
selecting "or" (in lower-case) will place an "or" operator between the two adjoining criteria. For example "Title contains 'Law'" or "Title contains 'Order'". Note that this example searches the same selected field. Although this is perfectly acceptable, you might want to consider using just one search criteria and entering the word "or" between your two or more words or "phrases". Note: You might have unexpected results if you use the "or" operator between two different fields. For example "Title contains the words or phrase 'Law'" or "Published Year is greater than '2010', although might be exacly what you intended!".
"OR {}" searches
selecting "OR {}" will separate the search in two or more parts, effectively grouping the search criteria each side of the "OR ()" operator. This would be similar to using brackets to group your search criteria. This will return results where the records are found in either the first part of the search (i.e. the criteria before the "OR") or the second, or subsequent, parts of the search (i.e. the criteria after the "OR").