按价格排序SQL数据类型VARCHAR [重复]

Question

This question already has an answer here:

• Convert text into number in MySQL query 9 answers

I want to order by price but type is varchar

my query = Select cost FROM table order by cost asc

result :

1.100.000
3.400.000
5.500.000
142.000
199.000
238.000
287.500
315.000
380.000
900.000

should:

142.000
199.000
238.000
287.500
315.000
380.000
900.000
1.100.000
3.400.000
5.500.000

How can I do it??

</div>

Answer 1

You can convert to a number:

order by replace(price, '.', '') + 0

Assuming that no prices start with "0" and all have the same format, you can use:

order by length(price), price