How to get random integer mysql range?

Question

I am trying to create a random integer for each line. I choose from 1 to 60 as a timer.

SELECT downloads.date, products.*, (FLOOR(1 + RAND() * 60)) AS timer 

I searched and continue to approach this FLOOR function to select a random integer in the range. This gives me 1 for each row. What am I missing?

I'm on mysql 5.0.75

Here is the rest of the request, I suppose it could be a nesting problem

 SELECT * FROM ( SELECT downloads.date, products.*, FLOOR(1 + (RAND() * 60)) AS randomtimer, ( SELECT COUNT( * ) FROM distros WHERE distros.product_id = products.product_id ) AS distro_count, (SELECT COUNT(*) FROM downloads WHERE downloads.product_id = products.product_id) AS true_downloads FROM downloads INNER JOIN products ON downloads.product_id = downloads.product_id ) AS count_table WHERE count_table.distro_count > 0 AND count_table.active = 1 ORDER BY count_table.randomtimer , count_table.date DESC LIMIT 10 

Answer 1

This works for me. Perhaps your version of mysql?

 SELECT id, (FLOOR( 1 + RAND( ) *60 )) AS timer FROM users LIMIT 0 , 30 

Answer 2

I fulfill your request and this gives me a random number for each line .... maybe it has something to do with the random name (timer)?

Answer 3

The output of the RAND function will always have a value between 0 and 1 .

Try the following:

 SELECT downloads.date, products.*, (CAST(RAND() * 60 AS UNSIGNED) + 1) AS timer 

Answer 4

You can increase the number times the number of entries in the table.

 SELECT id, (FLOOR( (SELECT MIN(id) FROM your_table ) + RAND( ) * 1000000 ) ) AS timer FROM your_table LIMIT 0 , 30