represents a search engine-style query in TextSearch and related functions.


  • The following can be used within the query:
  • term1 term2 terms that must all occur
    "term1 term2 "a string of terms that must occur literally
    +terma term that must occur
    -terma term that must not occur
    term~a term that should occur at least approximately
    "term1 term2 "~na string of terms that must occur at most n words apart
    field:forma form that should occur within a given field
    form^ba form that is to be boosted by b for purposes of ranking
  • The following additional and alternate forms are also supported:
  • term1 AND term2 AND terms that must all occur
    term2 OR term2 OR terms where at least one must occur
    NOT terma term that must not occur
    (query)grouping within a query string
    \ca character such as + or : that must occur verbatim


open allclose all

Basic Examples  (6)

Match an exact phrase:

A sequence of terms is interpreted as ContainsAll by default:

Search in a particular field:

Require "dog" but disallow "Alice":

A Boolean query where the weight of "lorem" is reduced:

Hyphenated words in queries match only the documents where the words appear both contiguously and in the same order:

Possible Issues  (2)

Wildcard searches interact with stemming, so "ali?" matches but "alic?" does not:

SearchQueryString can only be used when searching on an index:

Introduced in 2016