Check if values matchs in MongoDB

Question

I want to check with mongodb if nickname and password are true im trying to use the $and operator with $regex but I can't get it work. Can someone help me a hand with it currently have this;

checkNickname: function(nickname, password){
    var reNick = new RegExp(nickname, "i"),
        rePass = new RegExp(password, "i");
    getProfile.find( { $and :  [{
        nickname: { $ne: { $regex: reNick } } },
        { password: { $ne: { $regex: rePass} } } 
    ]}, function(data){
        console.log(data)
    });
},

score 7 · Accepted Answer · answered Nov 12 '15 at 20:34

This will do it for you,

    checkNickname: function(nickname, password){
        var reNick = new RegExp("/^" + nickname + ".*/", "i"),
            rePass = new RegExp("/^" + password + ".*/", "i");
        getProfile.find({ 
                    nickname: { $not: reNick },  
                    password: { $not: rePass }
            }, function(err, data) {
            console.log(data)
        });
    }

score 1 · Answer 2 · edited May 23 '17 at 12:03

1

As mention you can't have $regex as argument to $ne but you can negate your regex.

checkNickname: function(nickname, password){
    var reNick = RegExp("^((?!"+nickname+").)*$", "i");
    var rePass = new RegExp("^((?!"+password+").)*$", "i");
    getProfile.find( { nickname: reNick, password: rePass }, function(err, data) {
        console.log(data)
    });
};

edited May 23 '17 at 12:03

Community

1
1

answered Nov 12 '15 at 20:12

styvane

59,869
19
150
156

2

find function takes two arguments, first is always err so it must be `function(err, data) { if(err) throw err; console.log(data) });` – Hakan Kose Nov 12 '15 at 20:20
With `data` as second argument I get now a array but its empty I think that means no match is found. – I NA Nov 12 '15 at 20:25
Yes that is what it means – styvane Nov 12 '15 at 20:27

Check if values matchs in MongoDB

2 Answers2