I would like to know is there a way to select randomly generated number between 100 and 500 along with a select query Eg SELECT name address random number FROM users I dont have to store this number in db and only to use it to display purpose I tried it something like this but it can t get to work SELECT name address FLOOR RAND 500 AS random number FROM users Hope someone help me out Thank you

This should give what you want FLOOR RAND 401 100 Generically FLOOR RAND lt max gt - lt min gt 1 lt min gt generates a number between lt min and lt max gt inclusive Update This full statement should work SELECT name address FLOOR RAND 401 100 AS random number FROM users

creating a random number using MYSQL

The Solution to creating a random number using MYSQL is

This should give what you want:

FLOOR(RAND() * 401) + 100

Generically, FLOOR(RAND() * (<max> - <min> + 1)) + <min> generates a number between <min> and <max> inclusive.

Update

This full statement should work:

SELECT name, address, FLOOR(RAND() * 401) + 100 AS `random_number` 
FROM users

~ Answered on 2013-02-10 14:20:35

creating a random number using MYSQL

The Solution to creating a random number using MYSQL is

Most Viewed Questions: