mysql - 如何排序和选择带条件的查询

Question

我有以下查询:

SELECT * FROM table WHERE some conditions ORDER price ASC

整个查询有点多:

SELECT * FROM products WHERE some conditions ";
if (($_GET['Category']) =='X'){
switch( $_GET['price'] ){
    case '':
        $query_RS_Search .= ' some conditions ORDER BY price  ASC';
        break;
    case '0-500':
        $query_RS_Search .= ' some conditions ORDER BY price ASC';
        break;
    case '500-1000':
        etc
        break;  

}else{switch( $_GET['price'] ){
case '':
        $query_RS_Search .= ' some conditions ORDER BY price  ASC';
        break;
    case '0-500':
        $query_RS_Search .= ' some conditions ORDER BY price ASC';
        break;
    case '500-1000':
        etc
        break;  }}

我想做的是相同的查询，但价格是 0.00，这需要是最后一个而不是第一个。

例如我有以下产品:

product 1 price £15
product 2 price £25
product 3 price £12
product 4 price £0

我想按如下方式订购它们:

product 3 £12
product 1 £15
product 2 £25
product 4 £0

但是我得到的顺序是:

product 4 £0
product 3 £12
product 1 £15
product 2 £25

欢迎任何帮助

Answer 1

代替:

ORDER BY price ASC

使用:

ORDER BY IF(price = 0, 1, 0), price ASC

Demo here