MySQL查询中一致的随机顺序 [英] Consistent random ordering in a MySQL query

问题描述

我有一个图片数据库，我想让访问者浏览这些图片.我有一个下一个"和一个上一个"链接.

I have a database of pictures and I want to let visitors browse the pictures. I have one "next" and one "previous" link.

但是我要显示的是每个访客的花药顺序.我怎样才能做到这一点?如果我将使用ORDER BY RANDOM()，有时会显示重复的图像.

But what I want is to show every visitor anther order of the pictures. How can I do that? If I will use ORDER BY RANDOM() I will show sometimes duplicate images.

有人可以帮我吗?谢谢！

Can someone help me please? Thank you!

推荐答案

您可以尝试在随机函数中使用种子:

You can try to use seed in random function:

SELECT something FROM somewhere ORDER BY rand(123)

SELECT something FROM somewhere ORDER BY rand(123)

123是种子.随机应返回相同的值.

123 is a seed. Random should return the same values.

这篇关于MySQL查询中一致的随机顺序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！