Add a random number from 30 to 300 in an existing field

Question

I looked at the network in the same way as here, but I can not find the answer to the following MySQL question. I want to replace the value of an existing field with a query with a random number from 30 to 300. The reason was that I moved the galleries and had 250,000,000 views on my images, and there they were lost with migration, and many of my members are upset that they lost sight ....

Answer 1

UPDATE the_table SET the_field = the_field + FLOOR(RAND() * (270 + 1)) + 30 

Answer 2

Use RAND ()

 UPDATE table SET field = FLOOR(30 + (RAND() * 270)); WHERE foo = 'bar' 

Answer 3

I think this will do the trick:

 UPDATE table SET field = ROUND(30 + (RAND() * 270)) WHERE id =1;