cancel
Showing results for 
Search instead for 
Did you mean: 

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

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...

 

Thank you Ometv bazoocam

0 REPLIES 0