1👍
✅
You can filter with:
prefix = search[:2]
number = search[2:]
queryset = queryset.filter(
prefix=prefix,
low__lte=number,
high__gte=number
)
You can boost efficiency by setting a db_index=True
[Django-doc] on the low
and high
columns.
Source:stackexchange.com