MySQL按邮政编码排序，然后在每个邮政编码中随机排序

Question

我有一个正在运行的 SQL 查询:

SELECT * FROM listings, listings_categories 
    WHERE listings.id = listings_categories.listing_id AND category_id 
    IN (1,3,5,8,7,4,5,2) 
    AND business_zip IN (89101,89102,89103,89104,89105,89106) 
    AND status = '1' GROUP BY listings.id

是否有一种方法可以对结果进行排序，使其按 business_zip ASC 排序，但在每个邮政编码中随机化结果，还是我最好在 php 中处理它。

Answer 1

你可以有多种排序..

SELECT * FROM listings, listings_categories 
WHERE listings.id = listings_categories.listing_id AND category_id 
IN (1,3,5,8,7,4,5,2) 
AND business_zip IN (89101,89102,89103,89104,89105,89106) 
AND status = '1' GROUP BY listings.id
ORDER BY business_zip, RAND()