creating a random number using MYSQL

Question

I would like to know is there a way to select randomly generated numbers between 100 and 500 along with a select query.

Eg: SELECT name, address, random_number FROM users

I don't 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

I hope someone helps me out.Thank you

Answer 1

Try this code::

FLOOR(RAND() * 401) + 100

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

You can also try this:

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