Posted by Rik on 01/05/07 21:24

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]