I have a database of questions and I would like to be able to pull them
out randomly from the database using query.
I'm thinking of something along the lines of:
SELECT random() as RND,question
FROM Problems
ORDER BY RND;
Where random() is a user defined or built in function that returns a
random number.
Is this possible? Is there a better way to do this on the database
side. I could do it through code in the application, I'd just prefer not
to.
Shawn