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