Thread: MySql Help
View Single Post
Old 07-22-2012, 03:04 PM  
seeme
Stephen
 
Industry Role:
Join Date: Jun 2011
Location: Europe
Posts: 840
Quote:
Originally Posted by kazymjir View Post
Ahhhh, true.

Try this:
Code:
SELECT * 
   FROM (SELECT * FROM `items` ORDER BY RAND()) x
   GROUP BY x.group
   ORDER BY RAND();
Thanks thats what I needed
seeme is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote