Field Lookups - range
Example
Get all records where id is between 2 and 4:
mydata = Member.objects.filter(id__range=(2, 4)).values()
Run Example »
Definition and Usage
The range
lookup is used to get records that are between two values.
The field can be of any type, numeric string or dates.
Example
Get all records where firstname is alphanumeric between 'G' and 'M':
mydata = Member.objects.filter(firstname__range=('G', 'M')).values()
Run Example »
Note: When searching in text fields, remember that 'G' has a lower alphanumeric value than 'g'.
SQL Equivalent
The SQL equivalent to the two example above will be:
WHERE id BETWEEN 2 AND 4;
WHERE id BETWEEN 'G' AND 'M';
Syntax
All Field lookup keywords must be specified with the fieldname, followed by two(!) underscore characters
__
and the keyword:
fieldname__range=value