EN
MySQL - random value (in range)
4
points
In this short article, we would like to show how to random value in MySQL.
Quick solution:
SET @min := 50;
SET @max := 100;
SELECT ROUND(@min + (@max - @min) * RAND()) as `value`;
Where: returned value is in <50, 100) range where 100 value is excluded.
Practical examples
In <min, max) range - max excluded
SET @min := 50;
SET @max := 100;
SET @value := ROUND(@min + (@max - @min) * RAND());
SELECT @value as `value`;
In <0, max) range - max excluded
SET @max := 100;
SET @value := ROUND(@max * RAND());
SELECT @value as `value`;