How do I do a LIKE in mongoDB?

Question

db.courses.find({"course_number":"/^AFPRL/"}) returns nothing.

The following is my DB entry. Forgive me as I'm very new to MongoDB. I believe I'm trying to perform the equivalent of a LIKE operation in MySQL?

{
  _id: ObjectId("51072be2f046ed1c0e000000"),
  course_number: "AFPRL 100.00",
  room: "HW  215",
}

MongoRegex is your friend: http://php.net/manual/en/class.mongoregex.php — Sammaye, Feb 12 '13 at 22:28

score 3 · Accepted Answer · answered Feb 12 '13 at 22:34

3

The regular expression is not a string. It should be

db.courses.find({"course_number": /^AFPRL/})

answered Feb 12 '13 at 22:34

Infinity

Thanks, this helped out! This works when I input AFPRL, but when I put AFPRL 1, it breaks it. – user1426594 Feb 12 '13 at 22:43
Use \s to match whitespace – Infinity Feb 12 '13 at 22:50
How do I do that in c#? – Meir Nov 06 '15 at 11:17

1 Answers1