Question

我如何利用PHP从MySQL数据库中挑选单一随机条目?

我想选择作者、作者和日期?

Answer 1

SELECT Author, AuthorText, Date FROM table ORDER BY RAND() LIMIT 1

Answer 2

Take a look to this interesting article:
“Do not use ORDER BY RAND()” or “How to get random rows from table?”

Answer 3

ORDER BY rand() LIMIT 1

表中所有各行各行各行各行各行各行各行,这些行文可能极其缓慢。

更好的解决办法:说您的桌子拥有通常的主要汽车加油领域,在(id)和最大(id)之间产生一定数量,并选择最接近的门槛。

It will not be as random as a "true" random selection, because a id after a large hole of deleted ids will have a higher probability of being chosen. But it will take 50 µs instead of 2 seconds if your table is large...

SET @t = (SELECT FLOOR(a + (b-a)*rand()) FROM (SELECT min(id) as a, max(id) as b FROM table)
SELECT * FROM table WHERE id>@t ORDER BY id LIMIT 1;

Answer 4

You can order by a random & restrict to 1 row as follows:

select 
  author, authortext, date 
from bookstable 
order by rand()
limit 1

友情链接