Some content repositories support the ability to perform full text searches. The formats of the text strings and other search directives will vary from repository to repository. However, the basic query looks like this:
MATCH "mars"
This will return those items whose content matches mars in a full text search. (Content repositories allow parts of the item’s data to be designated as “content” for the purposes of display and searching).
Another form of the query allows the full text search to proceed over a particular property:
firstName MATCHES "abr"
Note that MATCH and MATCHES queries apply only to scalar properties.
Both forms of the query allow a special USING directive to pass special instructions to the underlying search engine. The format of this directive depends on the repository and whatever search engine it is using.
For example, to use the Sybase Full-Text Search Specialty Data Store, the query would look like this:
firstName MATCHES "abr" USING "SYBASE_SDS"
To use the Oracle ConText full text search engine, the query would look like this:
firstName MATCHES "abr" USING "ORACLE_CONTEXT"
