[_ck_]

Yup “order by rand()” is very handy.

I used it for a mod for WordPress years ago to make a “random” category which is very useful.

It could even be done to make a “random topics” view in bbPress but not sure how useful that would be.

It’s fine for casual use but keep in mind for larger tasks it’s very slow and makes mysql purists shudder.