Picking a random record from a db?

Question

MySQL

There is a working request code

SELECT id, name
FROM table
WHERE status = 1 ORDER BY MD5( CONCAT( ID, CURRENT_TIMESTAMP ) ) LIMIT 1

How productive is it and is there a better replacement?

Answer 1

Why don't you like it?

SELECT id, name
FROM table
WHERE status = 1 ORDER BY RAND() LIMIT 1

Answer 2

Both options are very costly. It is done in 2 requests.:
The first request gets the number of records. The second one asks for what you need with a random offset offset.