title: How to sort floating price values stored as varchar in mysql
body: <p>OK ,
  I have a little problem with some values from database
  ,i have 2 diferent type of value because i have column Price (varchar) and the problem is like that </p>
  
  <p>[<img src="https://i.stack.imgur.com/8jBV1.png" alt="picture]"></p>
  
  <p>i try to cast <code>select price from products order by CAST(price AS SIGNED)  asc</code> but without result because price without "." is not sorted very well</p>
  
  <p>Thanks !</p>