FullTextContainsAny (NoSQL query)

APPLIES TO: NoSQL

Returns a boolean indicating whether any of the provided string expressions are contained in a specified property path.

Syntax

FullTextContainsAny(<property_path>, <string_expr1>, <string_expr2>, ...)  

Arguments

Description
property_path The property path to search.
string_expr1 A string to find.
string_expr1 A string to find.

Return types

Returns a boolean expression.

Examples

This example returns all documents that contain either "keyword1" or "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, "keywords1", "keywords2")

This example returns all documents that contain "keyword1", "keyword2", or "keyword3" in the path c.text.

SELECT *
FROM c
WHERE FullTextContainsAll(c.text, "keyword1", "keyword2", "keyword3") 

Remarks