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:
xxxxxxxxxx1
SET @min := 50;2
SET @max := 100;3
4
SELECT ROUND(@min + (@max - @min) * RAND()) as `value`;Where: returned value is in <50, 100) range where 100 value is excluded.
xxxxxxxxxx1
SET @min := 50;2
SET @max := 100;3
4
SET @value := ROUND(@min + (@max - @min) * RAND());5
6
SELECT @value as `value`;xxxxxxxxxx1
SET @max := 100;2
3
SET @value := ROUND(@max * RAND());4
5
SELECT @value as `value`;
