FULLTEXTCONTAINS (NoSQL query)

The FULLTEXTCONTAINS function returns a boolean indicating whether the keyword string expression is contained in a specified property path.

Syntax

FULLTEXTCONTAINS(<property_path>, <string_expr>)

Arguments

Return types

Returns a boolean expression.

Examples

This section contains examples of how to use this query language construct.

Full text contains simple example

In this example, the FULLTEXTCONTAINS function is used to return 10 results that contain "search phrase" in the c.text property.

SELECT TOP 10 *
FROM c
WHERE FULLTEXTCONTAINS(c.text, "search phrase")

-- Example result not available (result not provided in markdown)

Full text contains with logical operators

In this example, the FULLTEXTCONTAINS function is used with logical operators to ensure multiple keywords or phrases are included.

SELECT *
FROM c
WHERE FULLTEXTCONTAINS(c.text, "keyword1") AND FULLTEXTCONTAINS(c.text, "keyword2")

-- Example result not available (result not provided in markdown)

Remarks

• This function requires enrollment in the Azure Cosmos DB NoSQL Full Text Search feature.
• This function benefits from a Full Text Index.