Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
APPLIES TO:
NoSQL
Returns a boolean indicating whether all of the provided string expressions are contained in a specified property path.
FullTextContainsAll(<property_path>, <string_expr1>, <string_expr2>, ...)
Description | |
---|---|
property_path |
The property path to search. |
string_expr1 |
A string to find. |
string_expr2 |
A string to find. |
Returns a boolean expression.
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")
- This function benefits from a Full Text Index