Found this:

select * from members order by rand() limit 1;

Note: This wasn\'t as fast as I had hoped. You may want to create your own system if you need a random record from a big table.

Related Scribbles:

MySQL Notes

---

ID: 382
Author:
leonard
Date Updated:
2004-01-06 14:50:59
Date Created:
2003-12-31 12:35:25

Edit

---

Comments?

 >> Leonard Chan's Homepage  >> Scribble Web  >> select random record mysql

leonard.lotus-land.ca is hosted by Perceptus Solutions Inc.