ORDER BY logical numbering, numbers

admin

Administrator
Staff member
I have many usernames in a mySQL table, like

user
user1
user2
user3
user10
user14
user20
user21

When I use an ORDER BY, it comes out, as you might expect, like

user
user1
user10
user14
user2
user20

How do I order these names logically?

TIA,
Jeff
 
Back
Top