mysql set random value on column
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); 
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);