Sorting numerically get order as 1,2,3 not 1, 10, 11, 12 in Django Python

Question

In reference to this for mysql ,I tried the following in my Django code

myQuery.order_by('myColumn+0')


myQuery.order_by('myColumn'+0)

but none worked for me

This is how [lexicographical ordering](http://en.wikipedia.org/wiki/Lexicographical_order) works... — ppeterka, Sep 30 '13 at 12:18
@ppeterka66 Yes i know this but I want to cope it !! if it is possible in mysql then there must be some way in django too — Deepanshu Goyal, Sep 30 '13 at 12:20
http://stackoverflow.com/questions/2969348/django-ordering-numerical-value-with-order-by — ppeterka, Sep 30 '13 at 12:23
Ensure the output from the database is numerical data and not strings. — Matt Seymour, Sep 30 '13 at 15:14

score 0 · Accepted Answer · answered Oct 01 '13 at 05:43

0

Well found the solution thanks to ppeterka 66

myQuery.filter().extra(
    select={'myinteger': 'CAST(mycharfield AS UNSIGNED)'}
).order_by('myinteger')

I used UNSIGNED instead of INTEGER, I guess my mysql doesnot support it

answered Oct 01 '13 at 05:43

Deepanshu Goyal

1 Answers1