MySql query for random id [duplicate]

Question

Possible Duplicate:
MySQL select 10 random rows from 600K rows fast

I need to pull from a table a random id. At this moment only a few records exists but with time they will grow. What methods of getting this id are in Php or MySql, and what are the trade offs, consequences between them. One last thing i need speed and performance.

Answer 1

select * from YOUR_TABLE order by rand() limit 1

Answer 2

You can achieve this direct in your SQL:

SELECT `idfield` FROM `table` ORDER BY RAND() LIMIT 0,1;

Also see here for some alternatives.

This will be a simple means of execution than building the randomisation in your PHP and then passing to mySQL, though the link above details the merits of the various approaches.