mongodb database search regex

Question

Each document consists of "name, city and branch" then they also contain "keywords" which is a combines version of "name, city and branch".

I now need a regular expression, this is what I got:

    public function searchLocation($keyword){
        $result = $this->locations->find(array('keywords' => new MongoRegex('/^' . strtolower($keyword) . '/')));

        if($result){
            return $result;
        }

        return false;
    }

Problem is, that when the user input was "grandcaffee london" it won't search for EACH word, or when the user inserts: "Cinema New York".

Thanks for reading.

Sergio Tulentsev · Accepted Answer · 2012-01-16 14:00:50Z

1

You can do this (matches "grandcaffee" OR "london")

db.locations.find({keywords: {$in: [/grandcaffee/, /london/]}});

or this (matches documents with BOTH "grandcaffee" and "london")

db.locations.find({keywords: {$all: [/grandcaffee/, /london/]}});

answered Jan 16, 2012 at 14:00

Sergio Tulentsev

231k43 gold badges381 silver badges373 bronze badges

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

Collectives™ on Stack Overflow

mongodb database search regex

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related