Quote:
Originally Posted by XYZTraffic
When I refresh the query I still get the same item from each group... just that the final list of items is ordered randomly.
|
Ahhhh, true.
Try this:
Code:
SELECT *
FROM (SELECT * FROM `items` ORDER BY RAND()) x
GROUP BY x.group
ORDER BY RAND();