How to search for multiple keywords over multiple columns in Django

Question

I want to be able to input a list of strings like so:

["searchterm1", "searchterm2", "searchtermN"]

And output all rows from the database where "searchterm1" matches one of the columns OR "searchterm2" matches one of the columns and so on.

Is there a way to do so?

you can use django [Q](https://docs.djangoproject.com/en/dev/topics/db/queries/#complex-lookups-with-q-objects) for or query — badiya, Apr 21 '17 at 20:39

score 5 · Accepted Answer · edited Feb 16 '21 at 07:44

from django.db.models import Q

def search(request):

    list_ = ["searchterm1", "searchterm2", "searchtermN"]

    q_object = Q(title__icontains=list[0]) | Q(description__icontains=list[0])

    for item in list_[1:]:
        q_object.add((Q(title__icontains=item) | Q(description__icontains=item)), q_object.connector)

    queryset = Product.objects.filter(q_object)

reference1 reference2

How to search for multiple keywords over multiple columns in Django

1 Answers1