[Answered ]-Filter object where queried number is within a range

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.

Leave a comment