php - 随机化特定组 mysql

Question

所以我有这行代码:

$results = mysql_query('
    SELECT * 
    FROM members 
    WHERE category1="Photographers" 
    ORDER BY premium DESC, featured DESC, company ASC');

一切正常，高级成员(member)出现在精选之上。精选在普通成员(member)之上，他们都是按字母顺序排列的。但是，我想让特色成员显示在普通成员之上，但随机而不是按字母顺序排列。我试过 RAND() 但它随机化了我所有的成员，请帮助。

Answer 1

SELECT * 
FROM members 
WHERE category1="Photographers" 
ORDER BY 
    premium DESC, 
    featured DESC, 
    CASE WHEN featured = 1 THEN RAND() ELSE company END ASC