在PHP或MySQL中排序十进制

Question

I am developing a ledger application. My main problem is that my client has Chart of Account with code like this

1.1.1, 
1.1.2 
...... 
1.1.10, 
1.1.11,
.........

Using PHP or MySQl I can only manage to sort them to

1.1.1, 
1.1.10, 
1.1.11,
1.1.2, 
.......

Any help on how to sort it so that 1.1.10 is coming after 1.1.9?

Thanks in advance.

Answer 1

if the sorting field is name then use the following ORDER BY clause

ORDER BY length(name), name