I have a table with articles with a number (like 1, 1.1, 1.1.1, 1.1.2, 1.2 and so on... 100.1, 10.2.3 and stuff...).
The field of the number is VARCHAR(25) 'cause otherwise I can't use
DOING A SELECT * .... ORDER BY number
I get this order
1
10
100
2
20
200
3
...
But I want
1
2
3
10
20
30
100
200
...
How can I solve this problem?
The field of the number is VARCHAR(25) 'cause otherwise I can't use
DOING A SELECT * .... ORDER BY number
I get this order
1
10
100
2
20
200
3
...
But I want
1
2
3
10
20
30
100
200
...
How can I solve this problem?