MongoDB C# Query for 'Like' on string

Question

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

Apparently there is a class called MongoRegex for that. stackoverflow.com/questions/2527443/…

Andrew Orsich · Accepted Answer · 2013-04-11 06:40:46Z

up vote 8 down vote accepted

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")

edited Apr 11 at 6:40

answered Dec 5 '11 at 8:58

Andrew Orsich
18.7k43964

You could just write: Query.Matches("name", "Joe") – Robert Stam Dec 9 '11 at 6:01

Gates VP · Answer 2 · 2011-12-05 08:40:02Z

up vote 4 down vote

MongoDB C# driver has a BsonRegex type that you can use.

Regex is the closest you will get to the SQL LIKE statement.

Note that prefixed Regexes can use indexes: /^Joe/ will use an index, /Joe/ will not.

answered Dec 5 '11 at 8:40

Gates VP
20.5k22850