如何让记录为空的排在后面? sql

复制内容到剪贴板

代码:

  $sql = "SELECT goods_id, goods_name, goods_type, goods_thumb,goods_sn, shop_price, is_on_sale, is_best, is_new, is_hot, sort_order, goods_number, integral, " .
                    " (promote_price > 0 AND promote_start_date <= '$today' AND promote_end_date >= '$today') AS is_promote ".
                    " FROM " . $GLOBALS['ecs']->table('goods') . " AS g WHERE is_delete='$is_delete' $where" .
                    " ORDER BY $filter[sort_by] $filter[sort_order] ".
                    " LIMIT " . $filter['start'] . ",$filter[page_size]";

引用:

原帖由 shirne 于 2011-6-1 13:49 发表
order by 后加上
IF(ISNULL(`goods_thumb`),1,2) desc,