How to select a random record from a MySQL database?

I am using the following query to select 1 ran开发者_运维技巧dom record -

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

but it gives me the same set of records every time I call it. How do I get better random record?

Try this:

SELECT * FROM tableName ORDER BY RAND() LIMIT 1