Random sort than sort by a specific column

0
291
SELECT * FROM infos WHERE category=...
ORDER BY rate DESC, NAME DESC, RAND();