PHP Mongo Regular expression

Question

I have mongo record as follows.

[1] => Array
    (
        [_id] => MongoId Object
            (
            )

        [id] => 195197
        [rec] => Array
            (
                [0] => Array
                    (
                        [id] => 195197
                        [data] => ways to skin a cat
                        [total] => 313
                    )

                 [1] => Array
                    (
                        [id] => 702724
                        [data] => 2010-07-25 15:09:40
                    )
            )

          [rec2] => Array
            (
                [0] => Array
                    (
                        [id] => 195197
                        [data] => ways to skin a cat
                        [total] => 313
                    )

                 [1] => Array
                    (
                        [id] => 702724
                        [data] => 2010-07-25 15:09:40
                    )
            )
    );

I want to search those records from mongo db having rec & rec2 element and having "data" element is in date format through Mongo regular expression. Is any way to find such records?

Community · Accepted Answer · 2023-11-17 20:42:18Z

5

From the shell you should be able to do something like the following:

db.foo.find( { 'rec.data' : /\d\d\d\d-\d\d-\d\d/ } )

From PHP, you would use the MongoRegex class.

Looks something like this:

$regex = new MongoRegex("/\d\d\d\d-\d\d-\d\d/");
$where = array("rec.data" => $regex);
$cursor = $db->foo->find( $where );

edited Nov 17, 2023 at 20:42

CommunityBot

11 silver badge

answered Feb 22, 2011 at 19:01

Gates VP

45.3k11 gold badges108 silver badges108 bronze badges

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

Comments

bigtallbill · Accepted Answer · 2012-01-23 12:04:17Z

2

Alternatively regular expressions can be expressed like so:

$where = array("rec.data"=>array('$regex'=>"\d\d\d\d-\d\d-\d\d", '$options'=>""));
$cursor = $db->foo->find( $where );

(i'm not sure if options can be omitted if it is blank so i've left it in)

answered Jan 23, 2012 at 12:04

bigtallbill

6316 silver badges12 bronze badges

Collectives™ on Stack Overflow

PHP Mongo Regular expression

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related