mySQL: Add random numbers to columns - Add random numbers within a pre-selected range to a given column.

Quick Search:

mySQL: Add random numbers to columns

Jump to:

Snippet Name: Add random numbers to columns

Description: Add random numbers within a pre-selected range to a given column.

Comment: (none)

Language: MYSQL
Highlight Mode: MYSQL
Last Modified: February 28th, 2009

UPDATE 'some_table'  SET some_column = FLOOR(RAND() * 21) + 122;