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