Excalibur text search types

The module supports various searches, such as keyword, Boolean, proximity, pattern (or fuzzy), and phrase. Phrase searching can be classified into two types: exact and approximate.

Use the SEARCH_TYPE tuning parameter to indicate what search you want to perform. A tuning parameter is a variable that you use to guide the way in which the text search engine performs a search. You pass this parameter to the search engine as the second input parameter of the Row() constructor of the etx_contains() operator.

The following sections provide examples of different types of searches. The examples use the same videos table described in Overview. Refer to The etx_contains() operator for a full list of supported tuning parameters.