Of course you can, if the table is indexed well and built properly. How would 
you normally do it in plain SQL?

Jeremy Burns
Class Outfit

http://www.classoutfit.com

On 19 Dec 2012, at 17:29:03, byqsri <[email protected]> wrote:

> If I have a milion of users I can't use a NOT IN condition
> 
> On Wednesday, 19 December 2012 18:21:06 UTC+1, byqsri wrote:
> Hi
> I'm newbie with cakephp
> I have model User, model Group and model UsersGroup ( an user can belongs to 
> many groups and a group can have many users).
> I would ask how in CakePHP can I find all users that not belong to the Group 
> group_id (where group_id is a generic int value)
> Many thanks
> 
> -- 
> Like Us on FaceBook https://www.facebook.com/CakePHP
> Find us on Twitter http://twitter.com/CakePHP
>  
> --- 
> 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].
> Visit this group at http://groups.google.com/group/cake-php?hl=en.
>  
>  

-- 
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP

--- 
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].
Visit this group at http://groups.google.com/group/cake-php?hl=en.


Reply via email to