FullTextContainsAll (NoSQL query)
APPLIES TO: 
NoSQL
Returns a boolean indicating whether all of the provided string expressions are contained in a specified property path.
Syntax
FullTextContainsAll(<property_path>, <string_expr1>, <string_expr2>, ...)
Arguments
| Description | |
|---|---|
property_path |
The property path to search. |
string_expr1 |
A string to find. |
string_expr2 |
A string to find. |
Return types
Returns a boolean expression.
Examples
This example finds all documents that contain both "keyword1" and "keyword2" in the path c.text, projects the path, and returns only the TOP 10.
SELECT TOP 10 c.text
FROM c
WHERE FullTextContainsAll(c.text, "keyword1", "keyword2")
This example returns all documents that contain "keyword1", "keyword2", and "keyword3" in the path c.text.
SELECT *
FROM c
WHERE FullTextContainsAll(c.text, "keyword1", "keyword2", "keyword3")
Remarks
- This function requires enrollment in the Azure Cosmos DB NoSQL Full Text Search preview feature
- This function benefits from a Full Text Index