且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

MySQL查询中一致的随机顺序

更新时间:2023-02-01 21:44:55

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

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.