Posted by thehuby on 01/05/07 21:39

Sir, you are a legend.

Rick

Rik wrote:

> thehuby wrote:
> > I have a table of articles and I want to grab 3 at random - is there a
> > way I can do this using SQL or will I have to get all results out then
> > pick them at random using PHP (something like rand() based on the size
> > of the result set?)
>
> SELECT .... ORDER BY RAND() LIMIT 3
> --
> Rik Wasmus

[Back to original message]