Does DocumentDB support the LIKE keyword in queries?

azure azure-cosmosdb
Joker_37 picture Joker_37 · Apr 16, 2016 · Viewed 12.3k times · Source

Can we use the LIKE keyword to filter out records as we use it in T-SQL?

Answer

cnaegle picture cnaegle · Apr 16, 2016

The keyword for LIKE is CONTAINS. If you had a document with a firstName property and you wanted to filter on the name 'bob' you would use it in a query this way:

"SELECT * FROM c WHERE CONTAINS(c.firstName, 'bob')"

Or if you were using Linq and assuming you had a class Person with a FirstName property the same query would work this way:

 var dbClient = GetClient();
 var docs = dbClient.CreateDocumentQuery<Person>(Collection)
                    .Where(p => p.FirstName.Contains("bob");

Related questions

Get record count in Azure DocumentDb

It seems like 'select count(*) from c' in the SQL queries allowed by documentdb in the azure site and through the documentdb explorer (https://studiodocumentdb.codeplex.com/) is not supported. To date, the only way to get a record count …

Read More
Azure Cosmos DB - Understanding Partition Key

I'm setting up our first Azure Cosmos DB - I will be importing into the first collection, the data from a table in one of our SQL Server databases. In setting up the collection, I'm having trouble understanding the meaning …

Read More
Delete Documents from CosmosDB based on condition through Query Explorer

What's the query or some other quick way to delete all the documents matching the where condition in a collection? I want something like DELETE * FROM c WHERE c.DocumentType = 'EULA' but, apparently, it doesn't work. Note: I'm not looking …

Read More