Find where id is not in array of ids

Question

To find id whose value is equal to the id of an array of ids:

$this->YourModel->find('all', array(
    'conditions' => array(
        "YourModel.id" => array(1, 2, 3, 4)
    )
));

How I can do the opposite, find elements where the ids are different than an array of ids?

score 35 · Accepted Answer · answered Jan 24 '13 at 19:17

35

This should work:

$this->YourModel->find('all', array(
    'conditions' => array(
        "NOT" => array( "YourModel.id" => array(1, 2, 3, 4) )
    )
));

answered Jan 24 '13 at 19:17

BigBagel

I'm using CakePHP 2.10 and this results in a DB error: SELECT `Division`.`division_id`, `Division`.`id` FROM `divisions` AS `Division` LEFT JOIN `division_types` AS `DivisionType` ON (`Division`.`division_type_id` = `DivisionType`.`id`) WHERE NOT (`Division`.`id` IN (1, 142, 143, 144, 168, 178, 18.... – Adam Friedman Jul 04 '20 at 00:26

1 Answers1