RE: [MLUG - DISCUSSION] random db results?

["Finn, Michael" <EMAIL:PROTECTED>]

As far as I know, a "random" result is right out, as far as SQL goes. But, you should get the snapshot of data that meets your criteria (view=0) so, then in your actual reporting application, just randomly determine if you will display a given record.

Finn

-----Original Message-----
From: Michael [mailto:EMAIL:PROTECTED]
Sent: Wednesday, July 03, 2002 7:21 AM
To: EMAIL:PROTECTED
Subject: [MLUG - DISCUSSION] random db results?


Does anyone know how to ask for random results from a db? Something like:

'SELECT id FROM files WHERE view = 0 GROUP BY random LIMIT 25'


The girl who stoops to conquer usually wears a low-cut dress.

;):):-):):-):):-)8')
Michael McGlothlin <EMAIL:PROTECTED>
http://kavlon.org/projects/

--
To unsubscribe, go to http://mlug.missouri.edu/members/edit.php

Archives are available at http://mlug.missouri.edu/list-archives/

--
To unsubscribe, go to http://mlug.missouri.edu/members/edit.php

Archives are available at http://mlug.missouri.edu/list-archives/