Django: ordering numerical value with order_by
Django is trying to deprecate the extra() method, but has introduced Cast() in v1.10. In sqlite (at least), CAST can take a value such as 10a and will cast it to the integer 10, so you can do:
from django.db.models import IntegerFieldfrom django.db.models.functions import CastMyModel.objects.annotate( my_integer_field=Cast('my_char_field', IntegerField())).order_by('my_integer_field', 'my_char_field')which will return objects sorted by the street number first numerically, then alphabetically, e.g. ...14, 15a, 15b, 16, 16a, 17...