NYCPHP Meetup

[Michael Sims]

On Thursday 01 September 2005 09:25, Cliff Hirsch wrote:

> I need to randomly access records from a database and have come up with
> the following solution:

> Any ideas?

SELECT field1, field2, rand() AS myrand FROM table ORDER BY myrand LIMIT 1;

It's a common problem.  With a solution that's easy, once you know it.  :)

Michael Sims