mysql对多个字段排序
order by param1, param2 desc
等同于
order by param1 asc, param2 desc
(param1顺序,params2倒序)
如果想要参数1和参数2都倒序排序
order by param1 desc, param2 desc
如果想要参数1和参数2整体来倒序排序
order by concat(param1, param2) desc
mysql对多个字段排序
order by param1, param2 desc
等同于
order by param1 asc, param2 desc
(param1顺序,params2倒序)
如果想要参数1和参数2都倒序排序
order by param1 desc, param2 desc
如果想要参数1和参数2整体来倒序排序
order by concat(param1, param2) desc