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