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?)

Any other approach anyone can recommend?

Rick

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

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