How to solve the sampling problem?

Question

PHP

I use this query to select 14 random records:

"SELECT r1.name FROM `objects` AS r1 JOIN (SELECT CEIL(RAND() * (SELECT MAX(id) FROM `objects`)) AS id)  AS r2 WHERE r1.id >= r2.id  ORDER BY r1.id ASC LIMIT 14

The problem is this: if there are only 100 records and this "code" RAND() * (SELECT MAX(id) FROM `objects`)returns 98 , then naturally only 2 records will be selected, instead of the 14 required, but you always need 14.
I also draw your attention to the fact that there are not 100 records, but only the maximum id is 100, i .e. this principle SELECT MAX(id)-14does not apply.
What should be the query to always select 14 random records?

Answer 1

Need 14 records in a row starting with a random one?

Answer 2

Isn't it better to use php to take 14 random numbers from the range in this case, and then just pull them out of the database?

Answer 3

Remove JOIN and add
ORDER BY RAND() LIMIT 14;

Answer 4

I draw your attention to the fact that it is ORDER BY RAND()unrealistically slow thing on a large number of records.