Field Lookups - range
Example
Get all records where id is between 2 and 4:
mydata = Member.objects.filter(id__range=(2, 4)).values()
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()
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
