How to sort Username correctly?
For example I do this query:
SELECT * FROM `members` WHERE username LIKE 'bx%' ORDER BY username ASC
Result:
bx1
bx10
bx11
bx12
bx13
bx14
bx15
bx16
bx17
bx18
bx19
bx2
bx20
bx21
bx3
bx4
bx5
I want to return like this:
bx1
bx2
bx3
bx4
bx5
...
bx15
bx16
and so on