2,306
edits
Changes
Jump to navigation
Jump to search
Line 58:
Line 58: + + + + +
→Query
| Not Equals || {<key>:{$ne:<value>}} || db.mycol.find({"likes":{$ne:50}}).pretty() || where likes != 50
| Not Equals || {<key>:{$ne:<value>}} || db.mycol.find({"likes":{$ne:50}}).pretty() || where likes != 50
|}
|}
AND / OR Example:<br />
Likes greater than 100 and whose title is either 'MongoDB Overview' or by is 'tutorials point'.<br />
Equivalent sql where clause is 'where likes>10 AND (by = 'tutorials point' OR title = 'MongoDB Overview')'
db.mycol.find({"likes": {$gt:10}, $or: [{"by": "tutorials point"}, {"title": "MongoDB Overview"}]}).pretty()