Logo Questions Linux Laravel Mysql Ubuntu Git Menu

mgo regular expression doesn't work

Now I have some documents, each of which has a key path and value like \A\, \B\, \A\C\, \A\C\D\, \A\E\, \A\E\F\.

I want to find the ones which have only 1 segment. It means the result should be \A\ and \B\. I use Regular Expression /^\\[^\\]*\\$/, which works fine in MongoDB terminal. But when I tried to apply it to Go programs it doesn't work.

Go codes:

var nodeList []NodeEntry // NodeEntry would match every field of one document
err = c.Find(bson.M{"path": bson.M{"$regex": bson.RegEx{"^\\[^\\]*\\$", ""}}}).All(&nodeList)



It's so strange, and then I found out that any Regex with \\ would produce an empty result.

So is it a bug of mgo?

(I don't know if it's inappropriate, but I've also posted this question on the mgo.users mailing list.)

like image 315
Melkor Avatar asked Mar 20 '23 22:03


2 Answers

In Go, the backslash (\) is the escape character of an interpreted string literal (using "..." as enclosures). In your case, you´d rather want to use a raw string literal (using `...` as enclosures).

Let's look at this piece of code:

package main

import "fmt"

func main() {



You can see that it is the second option that is the regex string you desire. So, to solve your problem, just enclose your regex string in backticks instead of quotes:

err = c.Find(bson.M{"path": bson.M{"$regex": bson.RegEx{`^\\[^\\]*\\$`, ""}}}).All(&nodeList)

Go spec reference: http://golang.org/ref/spec#String_literals

like image 78
ANisus Avatar answered Mar 29 '23 09:03


To add to @sandun-priyanka solution, if you want to make it case insensitive:

selector:= bson.M{"title": bson.M{"$regex": `(?i)`+wordOffset}}
like image 37
Oras Avatar answered Mar 29 '23 07:03