How to compare a string with a string array in mongodb query condition

Question

//PhoneProduct is model
//My schema has brand field with string type
var brands = ['apple', 'samsung'];
var QueryResult = PhoneProduct.find().where('brand').equals(brands));

Is there any way I get all document that have brand equal to any element in brands array ?

Well $in of course. Mongoose even has a helper QueryResult = PhoneProduct.find().where('brand').in(brands) — Neil Lunn
– Neil Lunn, Commented Jun 15, 2017 at 7:29
Thank you. Your code works. I've tested my above code and it also work. — Đinh Đức Thông
– Đinh Đức Thông, Commented Jun 15, 2017 at 8:12

hzitoun · Accepted Answer · 2017-06-15 09:03:08Z

1

var QueryResult = PhoneProduct.find({'brand': {$in: brands }})

edited Jun 15, 2017 at 9:03

answered Jun 15, 2017 at 7:22

hzitoun

5,8702 gold badges40 silver badges44 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

codeGig · Accepted Answer · 2017-06-15 07:40:02Z

1

You can not campare string with array, for this you need to check it belongs from array or not, Try This

//PhoneProduct is model
//My schema has brand field with string type
var brands = ['apple', 'samsung'];
var QueryResult = PhoneProduct.find({brand: {$in: brands}})

edited Jun 15, 2017 at 7:40

answered Jun 15, 2017 at 7:22

codeGig

1,0841 gold badge8 silver badges11 bronze badges

Comments

Bitdom8 · Accepted Answer · 2022-03-21 15:29:17Z

You can compare with for (i) meaning a loop:

var myobj0 = { symbols: { $in: ["#" + "AVAX"] } }
find('XDB, 'XCOLLECTION', myobj0).then(result => {
    console.log("These are here", result)
    for (i = 0; i < result.length; i++) {
        console.log("IDS:" + result[i].id)
        bot.sendMessage(result[i].id, message);
    }
})

You can also define the strength to match (as in Regex, but more efficient, since MongoDB built in)

const find = async (dbName, collectionName, json) => {
    try {
        const collection = client.db(dbName).collection(collectionName);
        const result = await collection.find(json).collation( { locale: 'en', strength: 2 }).toArray();
        return result;
    } catch (err) {
        console.error(err);
    }
}

Maybe you just want to compare some asset that is already built in too. Please check collations here on Mongo official manual

Collectives™ on Stack Overflow

How to compare a string with a string array in mongodb query condition

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related