title: Mysql order by: to skip zeros to end of list
body: <pre><code>$query = "SELECT products.*, login1.* 
            FROM products LEFT JOIN login1
                 ON products.id_user = login1.id_user
            WHERE products.product LIKE '".$search_keyword."'
            ORDER BY products.product, products.rate "
  </code></pre>
  
  <p>When using this query the products with rate 0 list first, But I want that to display last, with no other change in the order. How can I achieve this.</p>