In Django filter statement what's the difference between __exact and equal sign (=)?

django django-models django-orm
Alex picture Alex · Apr 1, 2012 · Viewed 10k times · Source

In Django filter statement what's the difference if I write:

.filter(name__exact='Alex')

and

.filter(name='Alex')

Thanks

Answer

MikeAr picture MikeAr · Apr 1, 2012

There is no difference, the second one implies using the __exact.

From the documentation:

For example, the following two statements are equivalent:
>>> Blog.objects.get(id__exact=14)  # Explicit form
>>> Blog.objects.get(id=14)         
# __exact is implied This is for convenience, because exact 
# lookups are the common case.

Related questions

Django values_list vs values

In Django, what's the difference between the following two: Article.objects.values_list('comment_id', flat=True).distinct() vs Article.objects.values('comment_id').distinct() My goal is to get a list of unique comment ids under each Article. I've …

Read More
What's the difference between select_related and prefetch_related in Django ORM?

In Django doc, select_related() "follows" foreign-key relationships, selecting additional related-object data when it executes its query. prefetch_related() does a separate lookup for each relationship, and does the "joining" in Python. What does it mean by "doing the joining …

Read More
Django database query: How to get object by id?

Django automatically creates an id field as primary key. Now I need to get the object by this id. object = Class.objects.filter() How to write this filter?

Read More