Mysql sorting using numbers and characters

Question

I am having a mysql table field with mixed values.Say,

1
2
Priya
Radha

If I sorts this in ascending order, the result will be displayed as shown above and if I sorts in descending order, the result will be

Radha
Priya
2
1

Here Mysql will give priority to numbers and then characters.

What to do, if I want Mysql to give priority to characters? ie, Sorting in ascending order should give a result like the one below:

Priya
Radha
1
2

Please help

possible duplicate of Sort mysql results alphabetically, but with numbers last. — Haim Evgi
– Haim Evgi, Commented Jun 15, 2011 at 10:54

royrui · Accepted Answer · 2011-06-15 11:01:53Z

1

I found this, maybe you can try it.

answered Jun 15, 2011 at 11:01

royrui

1,21710 silver badges20 bronze badges

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

1 Answer 1