MongoDB正则表达式使用$和

Question

I'm having problem to achieve this.

I have this piece of code which I had tested in Rock Mongo and it works fine.

array(
    'TEST' => 
    array( '$in' => 
        array( new MongoRegex('/^(?!TESTVALUE)/$ig'))
         )
     )

Above piece of code return me all documents which haven't value "TESTVALUE" for the key "TEST".

Now what I want to achieve?

First I don't know how to write piece of code to fetch all documents which haven't values "TESTVALUE" & "SECONDVALUE" for the key "TEST".

That will be something like this:

array(
    'TEST' => 
    array( '$in' => 
        array( new MongoRegex('/^(?!TESTVALUE)/$ig'),new MongoRegex('/^(?!SECONDVALUE)/$ig') )
        )
     )

And also I will need above piece of code written in PHP.

Any kind of help or suggestions is welcome and will be appreciated.

Thanks in advance

Answer 1

I don't think you can use $in like that, but this should work:

'TEST' => array('$and' => array(
    array('$regex' => new MongoRegex('/^(?!TESTVALUE)/$ig'),
    array('$regex' => new MongoRegex('/^(?!TESTVALUE)/$ig')))

something to that effect (untested)