Answers for "what is like operator sql in mongodb"

3

like mongodb

db.collection.find( { "url": { "$regex": ".*a.*"} } );
Posted by: Guest on March-20-2021
1

how to query mongodb with like

db.users.find({"name": /m/})
or
db.users.find({"name": /.*m.*/})

You're looking for something that contains "m" somewhere
(SQL's '%' operator is equivalent to Regexp's '.*'), 
not something that has "m" anchored to the beginning of the string.
Posted by: Guest on March-20-2021

Code answers related to "Shell/Bash"

Browse Popular Code Answers by Language