CakePHP: Find where field is not null

cakephp, php

Solution

I think this is what you mean:

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

Problem

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')))); ```

Original source