Quote:
Originally Posted by amphibient
Also (again) do you have any indexes on your table?
|
Yes i have indexes. About 15 000 rows.
SELECT id, col1, col2, ... , colN FROM tab WHERE id IN (SELECT id FROM tab WHERE conditions ORDER BY RAND() LIMIT m)
doesn't work in my version of mysql 4.1.22.
I want it to be as random as possible. Pulling them like 1 2 3 or 21 22 23 is out of question.