How to find fields by an array which contains multiple values by using like %% search

Question

I am trying to get multiple fields which match to those ids(1, 2, 3) by Like %% search. I have tried to make it work for two hours, but it hasn't worked though it looks pretty simple.

$ids = array ('1','2','3');

$result = $this -> Model -> find ('all', array(
    'conditions' => array( 'Model.category LIKE' => '%'.$ids.'%')
));

I need somebody's help.

possible duplicate of [CakePHP how to get multiple rows by array of ID's](http://stackoverflow.com/questions/6819865/cakephp-how-to-get-multiple-rows-by-array-of-ids) — kero, Dec 16 '14 at 13:59

score 1 · Answer 1 · answered Dec 17 '14 at 13:28

I'd suggest you build the 'conditions' array separately. For example:

$ids = array ('1','2','3');
$conditions = array();
foreach($ids as $id){
    $conditions['OR'][] = array( 'Model.category LIKE' => '%'.$id.'%')
}

$result = $this->Model->find('all', array('conditions'=>$conditions));

score 1 · Accepted Answer · answered Dec 28 '14 at 08:38

Sorry for the late reply, and thank you for answering my question. As long as I read your answers, the ansewer Nick Zinger posted was the most helpful. However, what I'd like to do was AND search. So I improved the answer like bellow.

$ids = array ('1','2','3');
$conditions = array();
foreach($ids as $id){
    $conditions['AND'][] = array( 'Model.category LIKE' => '%'.$id.'%')
}

$result = $this->Model->find('all', array('conditions'=>$conditions));

Again, I really appreciate for your helps.

score 0 · Answer 3 · edited May 23 '17 at 11:51

0

See CakePHP how to get multiple rows by array of ID's

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

edited May 23 '17 at 11:51

Community

1
1

answered Dec 16 '14 at 13:59

Vineet

4,525
3
23
42

This will not perform LIKE search – Royal Bg Dec 16 '14 at 14:02

score 0 · Answer 4 · answered Dec 16 '14 at 15:02

0

Just a guess but try it like

'Model.category LIKE' => "%$ids%"

answered Dec 16 '14 at 15:02

p0d4r14n

681
5
15

score 0 · Answer 5 · answered Dec 17 '14 at 18:12

0

Havent tested it but this should work

$ids = array(1, 2, 3);

$result = $this->Model->find('all', array(
    'conditions' => array('Model.category'=>$ids ')
        ));

answered Dec 17 '14 at 18:12

Jelle Keizer

723
5
9

How to find fields by an array which contains multiple values by using like %% search

5 Answers5