Quote:
Originally Posted by kazymjir
Code:
SELECT *
FROM `items`
GROUP BY `group`
ORDER BY RAND();
Selects one random item from each group |
When I refresh the query I still get the same item from each group... just that the final list of items is ordered randomly.