title: Multiple ascending order is not working in Mysql
body: <p>I have one table called as <code>request</code> and there are three columns called as <code>Id, want, teach</code>. I have to display <code>want</code> and <code>teach</code> column in ascending order and I don't want to display NULL and blank rows.</p>
  
  <p>I tried query only <code>want</code> column is displaying in ascending order but <code>teach</code> column is not displaying in ascending. </p>
  
  <pre><code>  SELECT want, teach FROM request WHERE want IS NOT NULL OR want !='' AND teach IS NOT NULL OR teach !='' GROUP BY want, teach ORDER BY want ASC, teach ASC
  </code></pre>
  
  <p>If I write ORDER BY teach ASC, want ASC then teach column is displaying in Ascending order and want is showing DESC order.
  Would you help me in this?</p>
  
  <p>Chech left side column is want and right side column is teach. I am getting output like this. left side column is ASC order but right side is showing DESC
  <a href="https://i.stack.imgur.com/C6Kvf.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/C6Kvf.jpg" alt="enter image description here"></a></p>