multiple LIKE conditions

0DownUp

Hello!

Could you, please, tell me if it is possible to query model table with multiple LIKEs?

I need something like that:

select FirstName, LastName from users

where (FirstName LIKE '%a' OR FirstName LIKE '%b' OR FirstName LIKE '%c')

AND (LastName LIKE '%a' OR LastName LIKE '%b' OR LastName LIKE '%c')

Thank you in advance,

Vlad

Asked by wesert, on 2/3/10

2 Answers

0DownUp

'or' => array(

array('Model.field1 LIKE ' => '%'.$abc.'%'),

array('Model.field1 LIKE ' => '%'.$xyz.'%')

),

'and' => array(

array('Model.field2 LIKE ' => '%'.$lkj.'%'),

array('Model.field2 LIKE ' => '%'.$uio.'%')

),

Answered by dogmatic69on 2/3/10

0DownUp

I think this will work:

$this->User->find('all', 
  array('conditions' => 
    array('and' => 
      array('or' => 
        array(
          'FirstName LIKE' => '%a', 
          'FirstName LIKE' => '%b', 
          'FirstName LIKE' => '%c'
        )
      ),
      array('or' => 
        array(
          'LastName LIKE' => '%a', 
          'LastName LIKE' => '%b', 
          'LastName LIKE' => '%c'
        )
      )
    )
  )
);

Answered by trevorsgon 2/3/10

<< previous next >>

Your Answer

You can use Creole Wiki Syntax to format your text.

Tagged with

Rating

0

Viewed

260 times

Last Activity

on 2/3/10

Related Questions