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...
04-22-2021 11:49 PM