从表中准确显示6个随机条目 [英] Displaying exactly 6 random entries from table

问题描述

我正在尝试显示6个随机的娱乐条目，但是根据我当前的查询，它会获得1到6之间的随机数，并显示该条目数。如何更新此查询以使其显示我的文章表中的6个随机娱乐条目？另外，我试图避免ORDER BY RAND（）。

I am trying to display exactly 6 random 'entertainment' entries, but with my current query it's getting a random number between 1 and 6, and displaying that number of entries. How do I update this query in order to make it display exactly 6 random entertainment entries from my Articles table? Also, I am trying to avoid ORDER BY RAND().

table Articles
 - id (int)
 - category (varchar)
 - title (varchar)
 - image (varchar)
 - link (varchar)
 - Counter (int)
 - dateStamp (datetime)

我尝试过：

What I have tried:

 SELECT
    r1.*
FROM
    Articles AS r1
    INNER JOIN (SELECT(RAND() * (SELECT MAX(id) FROM Articles)) AS id) AS r2
WHERE
    r1.id >= r2.id
    AND r1.category = 'entertainment'
LIMIT 6;

推荐答案

使用下面的代码。

Use below code.

Order by newid()

Use below code.
<pre>Order by newid()</pre>

这篇关于从表中准确显示6个随机条目的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！