MongoDB中find查询使用Perl兼容的正则表达式
perl中正则表达式简述：http://www.chinaunix.net/old_jh/25/159388.html
示例：
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
|
> db.post.
find
()
{
"_id"
: ObjectId(
"54a530c3ff0df3732bac1681"
),
"id"
: 2,
"name"
:
"joe"
,
"age"
: 30,
"sex"
: 1,
"school"
:
"marry"
}
{
"_id"
: ObjectId(
"54a530c3ff0df3732bac1680"
),
"id"
: 1,
"name"
:
"joe"
,
"age"
: 30,
"comments"
: [
"test2"
,
"test9"
,
"test5"
],
"sex"
: 1,
"school"
:
"marry"
}
{
"_id"
: ObjectId(
"54a9700e1b5afd45354fd086"
),
"id"
: 3,
"test3"
: 3 }
{
"_id"
: ObjectId(
"54a9701c1b5afd45354fd087"
),
"id"
: 4,
"test4"
: 4 }
{
"_id"
: ObjectId(
"54a970281b5afd45354fd088"
),
"id"
: 5,
"test5"
: 5 }
{
"_id"
: ObjectId(
"54a970351b5afd45354fd089"
),
"id"
: 6,
"test6"
: 6 }
{
"_id"
: ObjectId(
"54a970781b5afd45354fd08a"
),
"id"
: 7,
"test7"
: 7 }
{
"_id"
: ObjectId(
"54a970831b5afd45354fd08b"
),
"id"
: 8,
"test8"
: 8 }
{
"_id"
: ObjectId(
"54a970901b5afd45354fd08c"
),
"id"
: 9,
"test9"
: 9 }
{
"_id"
: ObjectId(
"54a9709c1b5afd45354fd08d"
),
"id"
: 10,
"test10"
: 10 }
{
"_id"
: ObjectId(
"54aa8a90652d8bdfa0566d34"
),
"id"
: 11,
"test10"
: 11 }
> db.post.
find
({
"school"
:
/m/i
})
{
"_id"
: ObjectId(
"54a530c3ff0df3732bac1681"
),
"id"
: 2,
"name"
:
"joe"
,
"age"
: 30,
"sex"
: 1,
"school"
:
"marry"
}
{
"_id"
: ObjectId(
"54a530c3ff0df3732bac1680"
),
"id"
: 1,
"name"
:
"joe"
,
"age"
: 30,
"comments"
: [
"test2"
,
"test9"
,
"test5"
],
"sex"
: 1,
"school"
:
"marry"
}
|
/模式/i , 表示系统接收//中指定的模式；
本文转自 bannerpei 51CTO博客，原文链接：http://blog.51cto.com/281816327/1599450，如需转载请自行联系原作者
