This question already has an answer here:
- SE Data: rand() fixed? 1 answer
I have been working on getting the Id of a random non closed question and came up with this:
Select Id from posts where ClosedDate IS NULL ORDER BY RAND()
For some reason I get the same results every time. Is this a bug or am I just doing this wrong?