Azure Cosmos DB

Filter documents with a substring.

SELECT * FROM c WHERE c.email LIKE "%substring%"