Field Lookups - in
Example
Get all records where firstname is one of the values in the list:
mydata = Member.objects.filter(firstname__in=['Tobias', 'Linus', 'John']).values()
Definition and Usage
The in lookup is used to get records where
the value is one of the values in an iterable (list, tuple, string, queryset).
The in lookup is case sensitive.
SQL Equivalent
The SQL equivalent to the example above will be:
WHERE firstname IN ('Tobias', 'Linus', 'John');
Syntax
All Field lookup keywords must be specified with the fieldname, followed by two(!) underscore characters
__ and the keyword:
fieldname__in=[value1,value2,value3,...]