How to Customize Search Results
- By default each word is optional
- A leading plus sign(+) indicates that the word must be present in every row returned.
- search: +obama
- returns: every row with the word obama present.
- A leading minus sign(-) indicates that the word must not be present in any row returned.
- search: president -obama
- returns: every row containing the word president without the word obama present.
- An asterisk(*) is the truncation operator. It indicates that the word must present anywhere within the text
- search: birth*
- returns: every row containing birth (birthday, birthplace).
- Double quotes at the beginning and end of a phrase, matches only rows that contain the complete phrase, as it was typed.
- search: "United States"
- returns: every row containing United States.
- Examples:
- search: +united -states
- returns: every row with word united that does not contain word states
- search: "President Obama" -elect
- returns: every row with phrase President Obama that does not contain word elect