Tutorials References Exercises Videos Menu
Website Get Certified Pro NEW

Field Lookups - icontains


Example

Do a case insensitive seatch for all records that have the value "ref" in the lastname column:

mydata = Members.objects.filter(lastname__icontains='ref').values()
Run Example »

Definition and Usage

The icontains lookup is used to get records that contains a specified value.

The icontains lookup is case insensitive.

For a case sensitive search, use the contains lookup.


SQL Equivalent

The SQL equivalent to the example above will be:

WHERE lastname LIKE '%ref%';

Syntax

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

fieldname__icontains='value'