How to update rand number in sql

Question

I want to update rand number Resolve this my problem

update abc set postion=rand() where status = 1

Anybody can help

```"UPDATE `abc` SET `position`='RAND(9)' WHERE `status`= 1"``` — Ritesh Khandekar, Nov 04 '19 at 05:01
Try [This](https://database.guide/mysql-rand-function-generate-a-random-number-in-mysql/) — Mike, Nov 04 '19 at 05:03
Possible duplicate of [creating a random number using MYSQL](https://stackoverflow.com/questions/14798640/creating-a-random-number-using-mysql) — Mike, Nov 04 '19 at 05:04

score 1 · Answer 1 · answered Nov 04 '19 at 05:16

1

for random no in float type

SELECT name, FLOOR( RAND( ) * (SELECT COUNT(*) FROM users)) + RAND() AS rand_no FROM users

for random no in integer type

SELECT name, FLOOR( RAND( ) * (SELECT COUNT(*) FROM users)) + 100 AS rand_no FROM users

answered Nov 04 '19 at 05:16

Yasir Mehmood

1 Answers1