CODEWITHSUNDEEP
mysqlsorting
Priya
Priya

Reputation: 1

Mysql sorting using numbers and characters

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

Upvotes: 0

Views: 824

Answers (1)

royrui
royrui

Reputation: 1207

I found this, maybe you can try it.

Sorting characters and numbers in mysql

Upvotes: 1

Related Questions