Tutorials Exercises Get Certified Services Menu
Log in
Sign Up Spaces Bootcamps

Field Lookups - endswith


Get all records where firstname ends with the letter "s":

mydata = Member.objects.filter(firstname__endswith='s').values()
Run Example »

Definition and Usage

The endswith lookup is used to get records that ends with a specified value.

The endswith lookup is case sensitive.

For a case insensitive search, use the iendswith lookup.

SQL Equivalent

The SQL equivalent to the example above will be:

WHERE firstname LIKE '%s';


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