Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select * from users where name like '%m%'
- db.users.find({"name": /.*m.*/})
- db.users.find({"name": /m/})
- db.users.insert({name: 'paulo'})
- db.users.insert({name: 'patric'})
- db.users.insert({name: 'pedro'})
- db.users.find({name: /a/}) //like '%a%'
- db.users.find({name: /^pa/}) //like 'pa%'
- db.users.find({name: /ro$/}) //like '%ro'
- db.users.find({'name': {'$regex': 'sometext'}})
- $collection->find(array('name'=> array('$regex' => 'm'));
- db.collection.find( { field: /acme.*corp/i } );
- //or
- db.collection.find( { field: { $regex: 'acme.*corp', $options: 'i' } } );
- db.collection.find( { field: new RegExp('acme.*corp') } );
- db.foo.insert({desc: "This is a string with text"});
- db.foo.insert({desc:"This is a another string with Text"});
- db.foo.ensureIndex({"desc":"text"});
- db.foo.find({
- $text:{
- $search:"text"
- }
- });
- db.users.find ({ "name" : /m/i } ).pretty()
- var queryA = Query.And(
- Query.Matches("strName", new BsonRegularExpression("ABCD", "i")),
- Query.Matches("strVal", new BsonRegularExpression("4121", "i")));
- var queryB = Query.Or(
- Query.Matches("strName", new BsonRegularExpression("ABCD","i")),
- Query.Matches("strVal", new BsonRegularExpression("33156", "i")));
- var getA = collections.Find(queryA);
- var getB = collections.Find(queryB);
- db.myCollection.find( { $where: "this.name.toLowerCase().indexOf('m') >= 0" } );
- select * from users where name like '%m%'
- db.users.find({"name": /m/}) // Not JSON formatted
- db.users.find({"name": /m/}).pretty() // JSON formatted
- db.users.find({'name': {'$regex': '.*sometext.*'}})
- Collection.Find(bson.M{"name": bson.RegEx{"m", ""}}).All(&result)
- db()->users->insert(['name' => 'john']);
- db()->users->insert(['name' => 'joe']);
- db()->users->insert(['name' => 'jason']);
- // starts with
- $like_var = 'jo';
- $prefix = '/^';
- $suffix = '/';
- $name = $prefix . $like_var . $suffix;
- db()->users->find(['name' => array('$regex'=>new MongoRegex($name))]);
- output: (joe, john)
- // contains
- $like_var = 'j';
- $prefix = '/';
- $suffix = '/';
- $name = $prefix . $like_var . $suffix;
- db()->users->find(['name' => array('$regex'=>new MongoRegex($name))]);
- output: (joe, john, jason)
- var User = mongoose.model('User');
- var searchQuery={};
- searchQuery.email = req.query.email;
- searchQuery. name = {'$regex': req.query.name};
- User.find(searchQuery, function(error, user) {
- if(error || user === null) {
- return res.status(500).send(error);
- }
- return res.status(200).send(user);
- });
- String tagName = "m";
- Query query = new Query();
- query.limit(10);
- query.addCriteria(Criteria.where("tagName").regex(tagName));
- db.movies.find({title: /.*Twelve Monkeys.*/}).sort({regularizedCorRelation : 1}).limit(10);
- val query = BSONDocument("title" -> BSONRegex(".*"+name+".*", "")) //like
- val sortQ = BSONDocument("regularizedCorRelation" -> BSONInteger(1))
- val cursor = collection.find(query).sort(sortQ).options(QueryOpts().batchSize(10)).cursor[BSONDocument]
- db.users.findOne({"name" : /.*sometext.*/});
- db.users.findOne({"name" : /.*sometext.*/i});
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement