mysql problem with random value
Posted: Sat Jul 17, 2004 8:42 pm
I have problem with get random id and total amount of rows for each kat.
GROUP always join rows selecting first rows. So it each time looks like this
How to solve this problem ?
Code: Select all
ID | KAT
1 1
2 3
3 3
4 2
5 2
6 2
7 1
8 1Code: Select all
SELECT COUNT(id), id, kat
FROM `table` GROUP BY kat
ORDER BY RAND()Code: Select all
kat, COUNT(id), id
1 , 3 , 1
2 , 3 , 4
3 , 2 , 2