PHP Mongo Query NOT NULL

Question

Anyone know the syntax for writing a php-mongo query to use NOT NULL?

I know how to do this when I query for NULL:

<?php
$cursor = $collection->find(array("someField" => null));

Is this even possible?

Mattias · Accepted Answer · 2012-03-20 18:31:31Z

20

Yeah, you want the $ne operator, so

$cursor = $collection->find(array("someField" => array('$ne' => null)));

edited Mar 20, 2012 at 18:31

Mattias

9,5013 gold badges44 silver badges42 bronze badges

answered Mar 20, 2012 at 18:22

jjm

6,2282 gold badges27 silver badges28 bronze badges

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

3 Comments

Michael Over a year ago

Thanks Jim. I just tried to post the same answer... but I don't have enough rep yet. I will accept your answer as soon as it will let me.

Tim Lytle Over a year ago

@jim Should be single quotes because of the $.

jjm Over a year ago

whoops on single quotes...haven't written php in a long time

Tim Lytle · Accepted Answer · 2012-03-20 18:28:34Z

2

Basically, the same kind of queries you would use on the Mongo console, you pass as an array to the query methods.

In your case, it could be (if you're checking that the field exists - note that the field could just be absent from the document):

array("someField" => array('$exists' => true))

Or to check if it's not equal to null:

array("someField" => array('$ne' => null))

Watch out for the $ in double quotes, since PHP will consider that a variable.

edited Mar 20, 2012 at 18:28

answered Mar 20, 2012 at 18:22

Tim Lytle

17.6k10 gold badges63 silver badges92 bronze badges

2 Comments

Michael Over a year ago

Thanks Tim, I was wondering how to check whether or not the field exists.

Tim Lytle Over a year ago

@MichaelIrey Yeah, with schema-less databases, there is a difference between 'is it null' and 'does it exist'.

Collectives™ on Stack Overflow

PHP Mongo Query NOT NULL

2 Answers 2

3 Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related