Is LIMIT RAND() CM of a range is possible or not?

bazoocamwebcam — Fri, 23 Apr 2021 06:49:57 GMT

Did anyone get any ideas about how to apply a random LIMIT within MySQL?

SELECT *, FLOOR(RAND() * (500-100) + 100) AS RandomValue

FROM customer

ORDER BY RAND()

LIMIT FLOOR(RAND() * (500-100) + 100);

ABove is doesn't either...

SELECT *, FLOOR(RAND() * (500-100) + 100) AS RandomValue

FROM customer

ORDER BY RAND()

LIMIT 100;

This is work...

topic Is LIMIT RAND() CM of a range is possible or not? in Integration and Testing