FullTextContains (NoSQL query)
APPLIES TO: NoSQL
Returns a boolean indicating whether the keyword string expression is contained in a specified property path.
Syntax
FullTextContains(<property_path>, <string_expr>)
Arguments
Description | |
---|---|
property_path |
The property path to search. |
string_expr |
The string to find. |
Return types
Returns a boolean expression.
Examples
This is a simple query returning 10 results that contain "keyword" in the c.text
property.
SELECT TOP 10 *
FROM c
WHERE FullTextContains(c.text, "keyword")
This next example shows logical operators used for ensuring multiple keywords are included.
SELECT *
FROM c
WHERE FullTextContains(c.text, "keyword1") AND FullTextContains(c.text, "keyword2")
Remarks
- This function requires enrollment in the Azure Cosmos DB NoSQL Full Text Search preview feature
- This function benefits from a Full Text Index