CODEWITHSUNDEEP
azure-cosmosdb
user911
user911

Reputation: 1559

Select IN query cosmos DB

How to write a select IN query in cosmos db/document db? Something similar to this

SELECT column_name(s)
FROM table_name
WHERE column_name IN (value1, value2, ...)

I am using Microsoft.Azure.DocumentDB.Core nuget package.

Upvotes: 0

Views: 298

Answers (1)

Sajeetharan
Sajeetharan

Reputation: 222582

Have you had a look at IN and CONTAINS?

FOR EX,

  SELECT *
    FROM Families
    WHERE Families.id IN ('AndersenFamily', 'WakefieldFamily')

Upvotes: 1

Related Questions