我有一个需求,需要按品牌分组并按其他列排序结果。
我从数组中获取品牌。
问题是,当我按品牌分组时,这个分组会按ID排序(在该分组内部)。
有没有一种方法可以在分组内部进行排序(order by)?
以下是我的数组和MySQL查询。
$laptop_brands = array("Acer", "Apple", "Dell", "HP-Compaq", "IBM-Lenovo", "Sony", "Toshiba", "ASUS", "Fujitsu", "Gateway");
$get_videos_query = "SELECT * FROM users_video WHERE location = 'location_1' AND brand IN ('" . implode("','", $laptop_brands) . '\') GROUP BY brand ORDER BY FIELD (brand, "Acer", "Apple", "Dell", "HP-Compaq", "IBM-Lenovo", "Sony", "Toshiba", "ASUS", "Fujitsu", "Gateway"), official DESC';
official
排序吗? - Justin Swanhart