Revisions to How to query MongoDB with "like"

Clearer name inserts for more meaningful examples

Source Link

edited Sep 14, 2022 at 16:03

6.9k
2
39
53

db.users.insert({name: 'paulo''patrick'})
db.users.insert({name: 'patric''petra'})
db.users.insert({name: 'pedro'})

Therefore:

For:

db.users.find({name: /a/})  // Like '%a%'

Output: paulopatrick, patricpetra

For:

db.users.find({name: /^pa/}) // Like 'pa%'

Output: paulo, patricpatrick

For:

db.users.find({name: /ro$/}) // Like '%ro'

Output: pedro

db.users.insert({name: 'paulo'})
db.users.insert({name: 'patric'})
db.users.insert({name: 'pedro'})

Therefore:

For:

db.users.find({name: /a/})  // Like '%a%'

Output: paulo, patric

For:

db.users.find({name: /^pa/}) // Like 'pa%'

Output: paulo, patric

For:

db.users.find({name: /ro$/}) // Like '%ro'

Output: pedro

db.users.insert({name: 'patrick'})
db.users.insert({name: 'petra'})
db.users.insert({name: 'pedro'})

Therefore:

For:

db.users.find({name: /a/})  // Like '%a%'

Output: patrick, petra

For:

db.users.find({name: /^pa/}) // Like 'pa%'

Output: patrick

For:

db.users.find({name: /ro$/}) // Like '%ro'

Output: pedro

fix spacing for syntax highlighting

Source Link

edited Aug 2, 2022 at 20:35

Akaisteph7

6.9k
2
39
53

db.users.insert({name: 'paulo'})
db.users.insert({name: 'patric'})
db.users.insert({name: 'pedro'})

Therefore:

For:

db.users.find({name: /a/})  // Like '%a%'

Output: paulo, patric

For:

db.users.find({name: /^pa/}) // Like 'pa%'

Output: paulo, patric

For:

db.users.find({name: /ro$/}) //like Like '%ro'

Output: pedro

db.users.insert({name: 'paulo'})
db.users.insert({name: 'patric'})
db.users.insert({name: 'pedro'})

Therefore:

For:

db.users.find({name: /a/})  // Like '%a%'

Output: paulo, patric

For:

db.users.find({name: /^pa/}) // Like 'pa%'

Output: paulo, patric

For:

db.users.find({name: /ro$/}) //like '%ro'

Output: pedro

db.users.insert({name: 'paulo'})
db.users.insert({name: 'patric'})
db.users.insert({name: 'pedro'})

Therefore:

For:

db.users.find({name: /a/})  // Like '%a%'

Output: paulo, patric

For:

db.users.find({name: /^pa/}) // Like 'pa%'

Output: paulo, patric

For:

db.users.find({name: /ro$/}) // Like '%ro'

Output: pedro

Fix and improve presentation

Source Link

edited Jun 1, 2021 at 17:25

Manuel Jordan

16.5k
26
113
187

db.users.insert({name: 'paulo'})
db.users.insert({name: 'patric'})
db.users.insert({name: 'pedro'})

Therefore:

For:

db.users.find({name: /a/})  // Like '%a%'

Output: paulo, patric

For:

db.users.find({name: /^pa/}) // Like 'pa%'

Output: paulo, patric

For:

db.users.find({name: /ro$/}) //like '%ro'

Output: pedro

db.users.insert({name: 'paulo'})
db.users.insert({name: 'patric'})
db.users.insert({name: 'pedro'})
 
db.users.find({name: /a/})  // Like '%a%'

Output: paulo, patric

db.users.find({name: /^pa/}) // Like 'pa%'

Output: paulo, patric

db.users.find({name: /ro$/}) //like '%ro'

Output: pedro

db.users.insert({name: 'paulo'})
db.users.insert({name: 'patric'})
db.users.insert({name: 'pedro'})

Therefore:

For:

db.users.find({name: /a/})  // Like '%a%'

Output: paulo, patric

For:

db.users.find({name: /^pa/}) // Like 'pa%'

Output: paulo, patric

For:

db.users.find({name: /ro$/}) //like '%ro'

Output: pedro

Active reading.

Source Link

edited May 11, 2021 at 14:18

Peter Mortensen

31.4k
22
110
134

Loading

Fixed the comments of similar like statements to match the expressions in the find

Source Link

edited Jan 28, 2015 at 18:53

scwagner

4k
23
16

Loading

Source Link

answered May 20, 2014 at 13:26

Johnathan Douglas

9.3k
2
16
7

Loading

Collectives™ on Stack Overflow

Return to Answer