Using the FREETEXT Predicate

With a FREETEXT predicate, you can enter any set of words or phrases, or even a complete sentence. The full-text query engine examines this text, identifies all the significant words and noun phrases, and internally constructs a query with those terms. This example uses a FREETEXT predicate against a column named description.

FREETEXT (description, ' "The Fulton County Grand Jury said Friday an investigation of Atlanta's recent primary election produced no evidence that any irregularities took place." ')

The search engine identifies the following words and noun phrases:

Words:

Fulton, county, grand, jury, Friday, investigation, Atlanta, recent, primary, election, produce, evidence, irregularities

Phrases:

Fulton county grand jury, primary election, grand jury, Atlanta’s recent primary election

The words and phrases (and their inflectionally generated variations) are internally combined into a query, weighted for proper ranking, and then the actual search is performed.

See Also