[GENERAL] Selecting Random Records

[shawn everett]

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