Replacing order by rand mysql

Are there any equivalents o开发者_如何转开发f order by rand?

---

While link from @Sandro explains why ORDER BY RAND() is bad, it gives no real solutions.

You should try reading this articles. And if it is too "dry", or you want to learn more about SQL, then you should look up SQL Antipatters book, or at least carefully look through authors slides.