2,306
edits
Changes
Jump to navigation
Jump to search
Line 41:
Line 41: + + + + + + + + + + + + + + + + +
→Query
db.COLLECTION_NAME.find()
db.COLLECTION_NAME.find()
db.COLLECTION_NAME.find({"name": "data1"})
db.COLLECTION_NAME.find({"name": "data1"})
RDBMS Where Clause Equivalents in MongoDB
{| class="wikitable"
|-
! Operation !! Syntax !! Example !! RDBMS Equivalent
|-
| Equality || {<key>:<value>} || db.mycol.find({"by":"tutorials point"}).pretty() || where by = 'tutorials point'
|-
| Less Than || {<key>:{$lt:<value>}} || db.mycol.find({"likes":{$lt:50}}).pretty() || where likes < 50
|-
| Less Than Equals || {<key>:{$lte:<value>}} || db.mycol.find({"likes":{$lte:50}}).pretty() || where likes <= 50
|-
| Greater Than || {<key>:{$gt:<value>}} || db.mycol.find({"likes":{$gt:50}}).pretty() || where likes > 50
|-
| Greater Than Equals || {<key>:{$gte:<value>}} || db.mycol.find({"likes":{$gte:50}}).pretty() || where likes >= 50
|-
| Not Equals || {<key>:{$ne:<value>}} || db.mycol.find({"likes":{$ne:50}}).pretty() || where likes != 50
|}