13.12.2016, 19:43
Quote:
Hi all. As you see, I want to set for one of the my MySQL tables random value, but I need to set not random (ex. 0, 1, 3, 4). I want to get 1 random value from 4 different values (ex. 2, 11, 5, 9).
Код HTML:
UPDATE `table_name` SET `some_thing` = 'FLOOR(1 + RAND() * 3)' WHERE `thing_some` = '1' |
this is proof : http://www.w3resource.com/mysql/math...d-function.php