How to select an object in which the field is the beginning of the line?

Question

Django

there is path = name1/qqqq/qq
in the table there is:
name=name1/q
name=name2
you need to extract the object with name=name1/q, because "name1/q" is the beginning of path.
ORM tools.

Answer 1

so it turned out
Model.objects.annotate(screen_name=V(path, output_field=CharField())).filter(screen_name__startswith=F('name'))

Answer 2

So just break the path into substrings. You can split on the symbol "/" and just throw the desired part of the substring as a parameter in sql