How does mysql randomly extract 10 entries from the database?

Problem
How to randomly extract 10 entries from the database?
Solution
Are there any good solutions, which are highly efficient and easy to use.


Reference answer
If you have a cache system... load it directly from the cache ....
Reference answer
No ~
Reference answer
Random syntax...
Reference answer
Why not use the Rand function?
Reference answer
Rand must be used, but I don't know how to write this SQL statement.
Reference answer
SELECT... FROM... WHERE... order by rand () LIMIT 10


Copy code
Reference answer
Posted by Fising at [url = http://bbs.111cn.cn/redirect.php? Goto = findpost & pid = 814691 & ptid = 100356] link mark [img] http://bbs.111cn.cn/images/common/back.gif?/img=#/url]
SELECT... FROM... WHERE... order by rand () LIMIT 10
Learning
Reference answer
Thank you. I wrote it like this just now, but the prompt is that the statement is incorrect. Is it true that rand must be capitalized? An error occurred while I wrote it in lower case.
Reference answer
[Url = http://www.linvo2008.cn/blog? P = 7] link tag http://www.linvo2008.cn/blog? P = 7 [/url]