DanCake DanCake - 4 years ago 183
PHP Question

CakePHP: Find where field is not null

I need to select all rows where User.site_url is not null. It's simple enough to do this in a regular MySQL query but how is this done in CakePHP?

The manual mentions the following:

array ("not" => array (
"Post.title" => null
)
)


I have tried the following but it's still returning everything

$this->User->find('all', array('conditions' => array('not' => array('User.site_url'))));

Answer Source

I think this is what you mean:

$this->User->find('all', array( 
    'conditions' => array('not' => array('User.site_url' => null))
));
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download