MySQL, sort integer character by character

Question

Is it possible to sort integers character by character?

So the list [110, 120, 10, 200, 20] would end up like this:

What have you tried? Which functions in the documentation did you rule out, and why? — Lightness Races in Orbit
– Lightness Races in Orbit, Commented Mar 15, 2012 at 16:46

Chris Young · Accepted Answer · 2012-03-15 16:45:24Z

4

If you cast the integer as a varchar or text value, and order by that cast, it should work.

ORDER BY CAST(myField AS CHAR)

answered Mar 15, 2012 at 16:45

Chris Young

1,81913 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ike Walker · Accepted Answer · 2012-03-15 16:46:29Z

0

SELECT num
FROM your_table
ORDER BY CAST(num as CHAR)

answered Mar 15, 2012 at 16:46

Ike Walker

65.8k14 gold badges115 silver badges112 bronze badges