What is the SQL ”LIKE” equivalent on Django ORM queries?

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’