title: Mysql order by not working properly
body: <p>I am using simple <code>order by</code> clause to show products according to available quantity </p>
  
  <p>Below is the  query I am using:</p>
  
  <pre><code>SELECT * FROM productsinfo ORDER BY quantity desc  
  </code></pre>
  
  <p>Query giving no error but sorting order is not correct.Anyone please tell me where I am wrong.</p>
  
  <p><strong>EDIT</strong></p>
  
  <p>Have checked my quentity clumn is <code>varchar</code> type.I am storing values in <code>1,215 10,456</code> format.</p>