php - 如何选择产品并按折扣 DESC 排序(PHP、Mysql)

Question

使用PHP和Mysql。
我的表(产品)中的字段是 id、full_price、sell_price 等

我如何选择产品 ORDER BY discount DESC，其中 discount = (full_price-sell_price) * 100/full_price？我尝试使用它，但它不起作用:

  SELECT *
    FROM product 
   WHERE full_price > 0 
ORDER BY (discount = (full_price - sell_price) * 100 / full_price) 
   LIMIT 10

Answer 1

如果您希望折扣也成为结果集中的一列，请这样做:

SELECT *, (full_price - sell_price) * 100 / full_price AS discount
FROM product
WHERE full_price > 0
ORDER BY discount DESC