sql “LIKE” equivalent in django query

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’