How to get mysql random integer range?

by

This is working for me. Your mysql version maybe?

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

More Related Contents:

  1. MySQL select 10 random rows from 600K rows fast
  2. How can i optimize MySQL’s ORDER BY RAND() function?
  3. quick selection of a random row from a large table in mysql
  4. Simple Random Samples from a Sql database
  5. Selecting random rows with MySQL
  6. How does MySQL’s ORDER BY RAND() work?
  7. How to select one row randomly taking into account a weight?
  8. quick selection of a random row from a large table in mysql
  9. Simple Random Samples from a MySQL Sql database
  10. UPDATE all records with a random number from a range
  11. Insert/ Update random date in MySQL
  12. MYSQL Select One Random record from each Category
  13. mysql unique number generation
  14. Error related to only_full_group_by when executing a query in MySql
  15. How to declare a variable in MySQL?
  16. Can you split/explode a field in a MySQL query?
  17. MySQL Cannot Add Foreign Key Constraint
  18. Grouping into interval of 5 minutes within a time range
  19. ERROR 1044 (42000): Access denied for user ”@’localhost’ to database ‘db’
  20. Difference between float and decimal data type
  21. Parse date in MySQL
  22. mysql dynamic query in stored procedure
  23. Table is ‘read only’
  24. Proper database model for a user feedback system (an interesting case)
  25. MySQL Errno 150
  26. MySQL – Replace Character in Columns
  27. How do you manage databases in development, test, and production?
  28. How do I add two count(*) results together on two different tables?
  29. Multi-Column Primary Key in MySQL 5
  30. mySQL regex in the where clause

Leave a Comment