MongoDB C# Query for 'Like' on string

gsagrawal picture gsagrawal · Dec 5, 2011 · Viewed 32.7k times · Source

i am using official mongodb c# driver. i want to query mongodb simliar to SQL Like something like db.users.find({name:/Joe/} in c# driver

Answer

Andrew Orsich picture Andrew Orsich · Dec 5, 2011

c# query will looks like:

Query.Matches("name", BsonRegularExpression.Create(new Regex("Joe")));

Update:

As per @RoberStam suggestion, there is more simple way to do this:

Query.Matches("name", "Joe")