|
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
Navigation:
[Reply to this message]
|