MySql查询随机id [复制]

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