Finding records whose object contains a String value

Question

I have a collection, the document in it looks like this:

{ 
    "person-name" : "Hughart, Ron", 
    "info" : { 
        "birthnotes" : [ "Los Angeles, California, USA" ], 
        "birthdate" : [ "18 June 1961" ], 
        "birthname" : [ "Hughart, Ronald P" ] 
    } 
}

I want to find the people who were born in Lisbon. The question is how do I know if a record's field "info.birthnotes" contains "Lisbon"?

I tried this command:

db.collection.find({"info.birthnotes": {"$in": ["Lisbon"]}})

but it returns nothing.

in your example info.birthnotes does not contain "Lisbon"

chirag
– chirag

2016-10-27 09:43:44 +00:00
Commented Oct 27, 2016 at 9:43 — chirag
– chirag, Commented Oct 27, 2016 at 9:43

chridam · Accepted Answer · 2016-10-27 10:02:26Z

1

From inspection, the "info.birthnotes" array may look like it has comma separated elements

"info.birthnotes" : [ "Los Angeles", "California", "USA" ]

yet it has a single string value "Los Angeles, California, USA" which is comma separated:

"info.birthnotes" : [ "Los Angeles, California, USA" ]

You are currently querying it as if it is multi-valued with single sttring values as elements. You need to use a $regex based query to return the documents whose "info.birthnotes" array string contains "Lisbon" as follows:

db.collection.find({ "info.birthnotes": { "$regex": /Lisbon/i } })

or if you are using a variable with the RegExp constructor to create a regular expression object you can use in your query:

var query = "Lisbon";
var rgx = new RegExp(query, "i");
db.collection.find({"info.birthnotes": rgx})

edited Oct 27, 2016 at 10:02

answered Oct 27, 2016 at 9:57

chridam

104k26 gold badges246 silver badges243 bronze badges

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

Comments

Webdev · Accepted Answer · 2016-10-27 09:56:20Z

0

The way to find is by using a regular expression

db.collection.find({"info.birthnotes": /.*Lisbon.*/})

answered Oct 27, 2016 at 9:56

Webdev

6671 gold badge7 silver badges28 bronze badges

Collectives™ on Stack Overflow

Finding records whose object contains a String value

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related