How to write this query

[hno]

 

I want to run a query that has two order by statment(order by star desc and order by random).I have a column in my table that is the number of stars that begin from 6 to 1 . I want to show all rows sorted by star and when for example  the star=6 then show them random and after that show star=5 random.How can do so?

 

thanks

[Alex]

SELECT * FROM table ORDER BY star DESC, RAND()