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

Field Lookups - gt (greater than, or equal to)


Get all records where id is 3 or larger:

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

Definition and Usage

The gte lookup is used to get records that are larger than, or equal to, a specified value.

For a greater than, but not or equal to, search, use the gt 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: