On 08/01/12 10:28, Àlex Pérez wrote: > Hi, > > it's better Person.objects.filter(models.Q(first_**name__startswith='mic'), > models.Q(first_**name__startswith='joh')) > (only one query...)
I'm pretty sure this will get you the intersection (it uses AND) rather than the union (which would be using OR). So I think you want from django.db.models import Q Person.objects.filter( Q(first_name__startswith="mic") | Q(first_name__startswith="joh") ) using the "|" (OR) operator to join the two Q objects. -tkc For reference, you can read at https://docs.djangoproject.com/en/dev/ref/models/querysets/#django.db.models.query.QuerySet.filter https://docs.djangoproject.com/en/dev/topics/db/queries/#complex-lookups-with-q-objects -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com. To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.
