Tutorials References Exercises Videos Menu
Website Get Certified Pro NEW

Field Lookups - in


Get all records where firstname is one of the values in the list:

mydata = Members.objects.filter(firstname__in=['Tobias', 'Linus', 'John']).values()
Run Example »

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');


All Field lookup keywords must be specified with the fieldname, followed by two(!) underscore characters __ and the keyword: