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?
Advertisement
Answer
Use __contains
or __icontains
(case-insensitive):
result = table.objects.filter(string__contains='pattern')
The SQL equivalent is
SELECT ... WHERE string LIKE '%pattern%';
@Dmitri’s answer below covers patterns like ‘pattern%’ or ‘%pattern’