正如你在docs中看到的，它会自动转义%和_，没有选项可以通过使用内置查找来不转义它。
因此，您可以使用.extra来编写原始SQL，这在大多数情况下都是不可取的，即使对于最复杂的情况也是如此。或者，编写自定义查找：
lookups.py

class Like(models.Lookup):
    lookup_name = "like"

    def as_sql(self, compiler, connection):
        lhs, lhs_params = self.process_lhs(compiler, connection)
        rhs, rhs_params = self.process_rhs(compiler, connection)
        params = lhs_params + rhs_params
        return "%s LIKE %s" % (lhs, rhs), params

models.CharField.register_lookup(Like)

views.py

from .lookups import Like

def some_view(request):
    name = ''
    author = ''
    annotation = '%harry%magic%school%'

    books = Book.objects.filter(
        Q(name__contains=name), 
        Q(author__contains=author), 
        Q(annotation__like=annotation)
    )
    print(books.query)
    return render(request, 'blank.html')

这将生成以下查询（print的输出）：

SELECT "myapp_book"."id", "myapp_book"."name", "myapp_book"."author", "myapp_book"."annotation" 
FROM "myapp_book" 
WHERE (
    "myapp_book"."name" LIKE %% ESCAPE '\' 
    AND "myapp_book"."author" LIKE %% ESCAPE '\' 
    AND "myapp_book"."annotation" LIKE %harry%magic%school%
)

**Obs：**您的所有条件都是针对name字段的，所以我只是假设它是错误的，并为每个变量更改它以匹配其各自的字段。