Note: I am not sure if this is a correct solution, but you can try this:
$data = $this->paginate('Recipe', array('Recipe.title LIKE' => 'a%',
'Recipe.recipe LIKE' => 'tasty%'));
Hope this helps,
Faifas
On Sat, Feb 21, 2009 at 13:14, himynameisjonas
<[email protected]> wrote:
>
> Hi, im trying to do a paginate with two LIKE conditions example:
> "...WHERE table.name LIKE %foo% OR table.name LIKE %bar%.."
>
> But i can't make the pageinate function handle two LIKE with OR, it's
> always uses an AND instead.
>
> any solution?
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
