【MongoDB】The Regex Expression query of MongoDB

In the past two blogs, the topic mainly focus on the high query operation of mongodb.In this blog, we simply study the regex expression in the mongdb.  MongoDB also support the regex query. For example

【MongoDB】The Regex Expression query of MongoDB

The expression is also able to combination with other expression.

【MongoDB】The Regex Expression query of MongoDB


Notes: /^a/; /^a.*/; /^a.*$/ have the same result, however the later two have less efficiency than the first one. Because the later will scan all the things, but the first only scan the first character. 

The item:

-i : ignore the upper or low case 

-m: the begin ‘^‘ and end‘$‘ do work on every new line;

-x: ignore the blank character

-s:  since 1.9 version, adding it could make ‘.‘ reprent all the character. 

for example:

/a.*b/ does not matches "apple\nbanana" but /a.*b/s does. 




【MongoDB】The Regex Expression query of MongoDB

上一篇:ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)


下一篇:查找数据库里所有表当前的最大id