Field lookups are how we specify the conditions in the WHERE clause of an SQL. They are specified as keyword arguments for QuerySet methodslike filter(), exclude() and get().
Check if the given string is contained in the value in database filed. It is translated to
SELECT * from entry WHERE headline LIKE '%ATEMON%';
Note this will match the headline
'ATEMON honored today' but not
'atemon honored today'.
SQLite doesn’t support case-sensitive LIKE statements; contains acts like icontains for SQLite. See the database note for more information.
Check if the given string is contained in the value in database filed, but case-insensitive.
SELECT * from entry WHERE headline ILIKE '%ATEMON%';
When using the SQLite backend and non-ASCII strings, bear in mind the database note about string comparisons.
We take the vision which comes from dreams and apply the magic of science and mathematics, adding the heritage of our profession and our knowledge to create a design.