Let’s say you have a table called “contact_table” and you want to find all the rows having “id” in the list.
Here is how we can write SELECT SQL command for the same.
SELECT * FROM contact_table WHERE id=[2, 3, 6, 7, 8]
How can we achieve that the same in Django web development project?
Let’s see.
Django has filter() method to filter out the query set.
Let’s say “Contact” model has field “id”. (By default it is autogenerated fields in the Django model). You can use any other field from the model.
Django has special __in operator that we can use with Django filter() method.
Contact.objects.filter(id__in=[2, 3, 6, 7, 8])
This will return query set from the model “Contact” after filtering a Django query with a list of values.
You can also write a query to exclude the filter object which has an id present in the list. For this, we are using exclude() method.
Contact.objects.filter().exclude(id__in=[2, 3, 6, 7, 8])
This will return all the contacts excluding which has an id not in the list.
Related Read:
I am a Python enthusiast who loves Linux and Vim. I hold a Master of Computer Science degree from NIT Trichy and have 10 years of experience in the IT industry, focusing on the Software Development Lifecycle from Requirements Gathering, Design, Development to Deployment. I have worked at IBM, Ericsson, and NetApp, and I share my knowledge on CSEstack.org.
