Tutorials References Exercises Bootcamp Menu
Sign Up Create Website Get Certified Upgrade

Field Lookups - lt (less than)


Get all records where id is less than 3:

mydata = Member.objects.filter(id__lt=3).values()
Run Example »

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;


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