GoFuckYourself.com - Adult Webmaster Forum - View Single Post

kazymjir · 07-22-2012, 11:18 AM

Code:

SELECT *
   FROM `items`
   GROUP BY `group`
   ORDER BY RAND();

Selects one random item from each group

07-22-2012, 11:18 AM
kazymjir Confirmed User Industry Role: Join Date: Oct 2011 Location: Munich Posts: 411	Code: SELECT * FROM `items` GROUP BY `group` ORDER BY RAND(); Selects one random item from each group __________________ http://kazymjir.com/