Menu
×
   ❮   
HTML CSS JAVASCRIPT SQL PYTHON JAVA PHP HOW TO W3.CSS C C++ C# BOOTSTRAP REACT MYSQL JQUERY EXCEL XML DJANGO NUMPY PANDAS NODEJS R TYPESCRIPT ANGULAR GIT POSTGRESQL MONGODB ASP AI GO KOTLIN SASS VUE DSA GEN AI SCIPY AWS CYBERSECURITY DATA SCIENCE
     ❯   

Field Lookups - startswith


Example

Get all records where firstname starts with the letter "S":

mydata = Member.objects.filter(firstname__startswith='S').values()
Run Example »

Definition and Usage

The startswith lookup is used to get records that starts with a specified value.

The startswith lookup is case sensitive.

For a case insensitive search, use the istartswith lookup.


SQL Equivalent

The SQL equivalent to the example above will be:

WHERE firstname LIKE 'S%';

Syntax

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

fieldname__startswith='value'