Multiple icontains using OR - Is it possible?

[tm]

Hello Django Users,

I'm trying to use icontains to check 2 fields in the same table for a
keyword entered into a search.

ex I've tried:

queryset = MyModel.objects.filter(summary__icontains=q).filter
(title__icontains=q)

and

queryset = MyModel.objects.filter(summary__icontains=q,
title__icontains=q)

Neither work, although judging by the docs the second one shouldn't in
this case. Has anyone successfully searched a MySQL DB using
icontains on 2 filelds in the same model? Any help greatly
appreciated :)

T

[HARRY POTTRER]

you're going to need the Q object, it seems.

from django.db.models import Q
MyModel.objects.filter(Q(summary__icontains=q) | Q
(title__icontains=q))

[tm]

This worked! Thank you