php - Mysql按: to skip zeros to end of list排序

Question

$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 "

当使用此查询时，率 0 的产品首先列出，但我希望它最后显示，顺序没有其他变化。我怎样才能做到这一点。

Answer 1

试试这个:

$query = "
  SELECT products.*, login1.*
  FROM products
  LEFT JOIN login1 ON products.id_user = login1.id_user
  WHERE products.product LIKE '" . $search_keyword . "'
  ORDER BY IF(products.rate = 0, 1, 0), products.product, products.rate "

这会在排序顺序中添加初始检查，以便产品的速率为 0在费率不等于 0 的所有产品之后列出.