用mysql插入随机数

Question

i have a question in regards to mysql mainly. i have the following:

mysql_query("INSERT INTO {$game}_ships (location,login_id
         ) values(
    '250','44')");

i would like to make the location a random number from 2 to 300.

my table structure includes among others a column for location and login id, i dont need to mention other columns as they are static and do not change. the above is suposed to make a ship look like its moving around the systems.

location   int(4)

can anyone help with this?

Answer 1

mysql_query("INSERT INTO {$game}_ships (location,login_id
         ) values(
    FLOOR(RAND() * 298 + 2),'44')");

See: http://dev.mysql.com/doc/refman/5.0/en/mathematical-functions.html#function_rand