sql "LIKE" equivalent in django query

python sql django django-models django-queryset
Aswin Murugesh picture Aswin Murugesh · Aug 9, 2013 · Viewed 89.3k times · Source

What is the equivalent of this SQL statement in django?

SELECT * FROM table_name WHERE string LIKE pattern;

How do I implement this in django? I tried

result = table.objects.filter( pattern in string )

But that did not work. How do i implement this?

Answer

falsetru picture falsetru · Aug 9, 2013

Use __contains or __icontains (case-insensitive):

result = table.objects.filter(string__contains='pattern')

The SQL equivalent is

SELECT ... WHERE string LIKE '%pattern%';

Related questions

LEFT JOIN Django ORM

I have the following models: class Volunteer(models.Model): first_name = models.CharField(max_length=50L) last_name = models.CharField(max_length=50L) email = models.CharField(max_length=50L) gender = models.CharField(max_length=1, choices=GENDER_CHOICES) class Department(models.…

Read More
manage.py sql command for django models - Django

just wondering... but is it possible to generate SQL commands for django's models? e.g. the session model python manage.py sql django Any ideas?

Read More
Getting the SQL from a Django QuerySet

How do I get the SQL that Django will use on the database from a QuerySet object? I'm trying to debug some strange behavior, but I'm not sure what queries are going to the database. Thanks for your help.

Read More