MongoDB: How to find documents containing a string in subdocuments in any fields without specifying array index?

Question

I want to find all documents containing the word "school" in ANY of their subdocuments fields, for example, if we have two documents:

{
    name: "aa",
    schools: [
        {
            name: "high school",
            description: "aaaa"
        },
        {
            name: "a1",
            description: "blabla bla school"
        },
        ...
    ],
},
{
    name: "bb",
    schools: [
        {
            name: "bbb",
            description: "First school of ..."
        },
        {
            name: "b school",
            description: "bbb  bb b",
            ...
        }
    ],
},

These documents should match with the name or/and description of the first or/and second school.

I tried this query without success:

{
    schools: /.*school.*/
}

And this too, by listing fields:

{
    school: [
        { name: /.*school.*/ },
        { description: /.*school.*/ },
        ...
    ]
}

Is their a way to perform this?

JohnnyHK · Accepted Answer · 2016-02-24 13:37:11Z

4

If you need a true wildcard query, then @a-h's answer regarding a text index is the way to go. But you can also do this with an $or query that checks multiple fields for matches:

db.schools.find({
  $or: [
    { 'schools.name': /school/ },
    { 'schools.description': /school/ },
    ...
  ]
})

answered Feb 24, 2016 at 13:37

JohnnyHK

313k70 gold badges632 silver badges479 bronze badges

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

Comments

a-h · Accepted Answer · 2016-02-22 16:02:57Z

3

The easiest way is to create a full-text index.

You can do this by following the documentation at https://docs.mongodb.org/manual/core/index-text/

The index can then be queried with the $text operator: https://docs.mongodb.org/manual/reference/operator/query/text/

Create Index on All Fields

db.schools.createIndex( { "$**": "text" } )

Search

db.schools.find({
  $text:
    {
      $search: "school",
      $language: "en",
      $caseSensitive: false,
      $diacriticSensitive: false
    }
})

answered Feb 22, 2016 at 16:02

a-h

4,3042 gold badges26 silver badges30 bronze badges

1 Comment

Genjo Over a year ago

This response works too, but a wildcard index on all string data in my collection would be too big I think or not usefull. Thanks anyway!

Collectives™ on Stack Overflow

MongoDB: How to find documents containing a string in subdocuments in any fields without specifying array index?

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related