Hi all,
Does anybody know how to change MySQL's ORDER BY criteria so it orders in natural order, ie:
Instead of string ordering:
1
10
11
2
3
4
5
6
7
8
9
I need:
1
2
3
4
...
The problem is, the field is a string field (CHAR) and it's ordering the results incorrectly.
Any ideas? Thanx a stack!
-- John G
Does anybody know how to change MySQL's ORDER BY criteria so it orders in natural order, ie:
Instead of string ordering:
1
10
11
2
3
4
5
6
7
8
9
I need:
1
2
3
4
...
The problem is, the field is a string field (CHAR) and it's ordering the results incorrectly.
Any ideas? Thanx a stack!
-- John G