MangoDB: select where like

Question

I'm just trying out the Kohana MongoDB ORM: MangoDB. I'm trying to figure out how to do a where like.

$query['city'] = $this->request->query('location');
$results = Mango::factory('salon')
    ->load(array(
        'limit' => null,
        'criteria' => $query
    ));

I want to change this to do a where like:

SELECT * FROM salon WHERE city LIKE '%London%'

find("city":/London/) - see section on regular expressions in querying in MongoDB docs. — Asya Kamsky, Apr 22 '13 at 19:55

score 0 · Accepted Answer · answered Apr 23 '13 at 08:00

0

MongoDB supports regular expressions:

db.collection.find( { city: /*London*/i } );

See documentation here: http://docs.mongodb.org/manual/reference/operator/regex/

answered Apr 23 '13 at 08:00

rakhim

164
8

MangoDB: select where like

1 Answers1