Field Lookups - lt (less than)
Example
Get all records where id is less than 3:
mydata = Member.objects.filter(id__lt=3).values()
Definition and Usage
The lt lookup is used to get records that are less than
a specified value.
For a less than or equal to search, use the lte lookup.
SQL Equivalent
The SQL equivalent to the example above will be:
WHERE id < 3;
Syntax
All Field lookup keywords must be specified with the fieldname, followed by two(!) underscore characters
__ and the keyword:
fieldname__lt=value
