Full text search options compatibility
A full text search always starts with a Contains in FTS operator, but that still leaves open a variety of options for forming a query for the full text search engine. These options include a number of full text query operators, connectors and modifiers that vary depending on whether or not the boolean option is checked or not or the search type is "Raw query".
Contains in DB works with the database and not the full text search index. The options for this operator are different than for Contains in FTS.
| Operator or modifier | Description | Basic FTS query | Boolean or raw FTS query |
|---|---|---|---|
| - (minus) | Logical NOT | X | |
| not | Logical NOT | X | |
| or | Logical OR | X | X |
| and | Logical AND | X | |
| "" (double quotes) | Exact phrase | X | X |
| w/N | Forward proximity | X | |
| pre/N | Reverse proximity | X | |
| :: (double colon) | Field contains | X1 | |
| contains | Field contains | X1 | |
| to | Dynamic field end point connector | X | |
| andany | Mandatory and optional word connector | X | |
| ? (question mark) | Single character match wildcard | X | X |
| * (asterisk) | Multiple character match wildcard | X | X |
| = | Single number match wildcard | X | X |
| % (percent) | Fuzzy content modifier | X | X |
| # (hash) | Phonic search prefix | X | X |
| ~ (tilde) | Stemming modifier | X | X |
| & (ampersand) | Synonym search modifier | X | X |
| ~~ (double tilde) | Numeric range connector | X | X |
| : (colon) | Variable term weighting | X | X |
| ## (double hash) | Regular express prefix | X | X |
| xfirstword | Beginning of file proximity anchor | X | |
| xlastword | End of file proximity anchor | X | |
| xfilter | File condition function | X |
1 Field contains operations are not possible for File only or Metadata only searches as those search types are already searching inside a field.