How does mysql randomly extract 10 entries from the database ?. How can we randomly extract 10 entries from the database? Is there a good solution, high efficiency, and simple solution. If you have a cache system...
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
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]
How to randomly extract 10 entries from the database? Is there a good solution, high efficiency, and simple solution. If you have a cache system...