php - MySQL query on money format -
i got table prices has values similar following: price ----------- 21,781.00 27,615.00 46,565.00 46,565.00 48,565.00 571.00 830.00 0.00 by doing query: select * tprice order price=0, convert(price, decimal) asc i following result: 21,781.00 27,615.00 46,565.00 46,565.00 48,565.00 571.00 830.00 and, doing query: select * tprice order price=0, convert(price, decimal) desc i 830.00 571.00 48,565.00 46,565.00 46,565.00 27,615.00 21,781.00 0.00 why 830.00 , 571.00 not been ordered properly? edit: i've changed query to: select * tprice order price=0, replace(',','',price), price asc it seems working "a bit better". result: 830.00 571.00 48,565.00 46,565.00 46,565.00 27,615.00 21,781.00 0.00 still trying other variations... select price, convert(replace(replace(price, ",", ""), ".", ""),unsigned integer) formattedprice testtest order formattedprice; this should work. explana...