How to select a random record from MySQL database?

Question

I am using the following query to select 1 random entry -

SELECT name FROM table WHERE id >= (SELECT FLOOR( MAX(id) * RAND()) FROM table ) ORDER BY id LIMIT 1

but it gives me the same recordset every time I call it. How can I improve random recording?

+2

Bruce May 06 '10 at 5:19

1 answer

Delan azabani · Accepted Answer · 2010-05-06T05:24:36+0000

Try the following:

SELECT * FROM tableName ORDER BY RAND() LIMIT 1