db.test.find()<==> select from test

db.test.find({'name':'foobar'})<==> select from test where name='foobar'

db.test.find({'ID':10}).count()<==> select count() from test where ID=10

db.test.find().skip(10).limit(20)<==> select from test limit 10,20

db.test.find({'ID':{$in:[25,35,45]}})<==> select from test where ID in (25,35,45)

db.test.find().sort({'ID':-1}) <==> select from test order by ID desc

db.test.distinct('name',{'ID':{$lt:20}}) <==> select distinct(name) from testwhere ID<20

db.test.group({key:{'name':true},cond:{'name':'foo'},reduce:function(obj,prev){prev.msum+=obj.marks;},initial:{msum:0}}) <==> select name,sum(marks) from testgroup by name

db.test.find('this.ID<20',{name:1}) <==> select name from test where ID<20

<?php
$m = new MongoClient();
$db = $m->selectDB('test');
$collection = new MongoCollection($db, 'produce');
// search for fruits
$fruitQuery = array('Type' => 'Fruit');
$cursor = $collection->find($fruitQuery);//
// search for documents where 5 < x < 20
$rangeQuery = array('x' => array( '$gt' => 5, '$lt' => 20 ));
$cursor = $collection->find($rangeQuery);
//
$js = "function() {
return this.name == 'Joe' || this.age == 50;
}";
$cursor = $collection->find(array('$where' => $js))
//where name in ()
$cursor = $collection->find(array(
'name' => array('$in' => array('Joe', 'Wendy'))
));
?>

db.test.insert({'name':'foobar','age':25})<==>insert into test ('name','age') values('foobar',25)

<?php
$collection->insert(array('x' => 1));
?>

db.test.remove({})<==> delete * from test

db.test.remove({'age':20})<==>delete test where age=20

db.test.remove({'age':{$lt:20}})<==> delete test where age<20

db.test.remove({'age':{$lte:20}})<==> delete test where age<=20

db.test.remove({'age':{$gt:20}})<==> delete test where age>20

db.test.remove({'age':{$gte:20}})<==> delete test where age>=20

db.test.remove({'age':{$ne:20}})<==> delete test where age!=20

<?php
$radioactive->remove(array('type' => 94), array("justOne" => true));
?>

db.test.update({'name':'foobar'},{$set:{'age':36}})<==> update test set age=36 where name='foobar'

db.test.update({'name':'foobar'},{$inc:{'age':3}})<==> update test set age = age+3 where name='foobar'

<?php
$newdata = array('$set' => array("address" => "1 Smith Lane"));
$c->update(array("firstname" => "Bob"), $newdata);
?>

db.imooc_collection.update({x:1},{x:999}) //把x=1的改成x=999的，只更新一条
db.imooc_collection.update({x:1},{$set:{y:100}}) //单个字段更新
db.imooc_collection.update({x:999},{x:777},true) //更新数据，如果不存在，创建
db.imooc_collection.update({x:999},{$set{x:777}},false,true) 更新多条
db.imooc_collection.remove({x:777}) //删除x=777
db.imooc_collection.drop() //删除表imooc_collection
db.imooc_collection.getIndexes() //查询索引
db.imooc_collection.ensureIndex({x:1}) //增加索引