mysql set random value on column

Written by Peter Davies on .

Useful blog post from Gareth Price on a one-line MySQL query for creating a random value in a column, in our case we needed 500-2000 values:

UPDATE job_rma SET cntloops = CAST((RAND() * 2000)+500 AS UNSIGNED);