随机数 - php mysql 带查询条件 获取多条随机记录

Answer 1

It’s best to leave this to PHP, for example, randomize the ID in advance

Answer 2

Get 10 random records with query conditions:

SELECT * FROM yourTable WHERE yourTable.status=0 ORDER BY RAND() LIMIT 10;

The consumption will be very large, use it as appropriate after testing.